Forms :: How To Show Total Number Of Records In Text Item

May 3, 2013

I have a multi record field of five rows. And 3 values.

the values are

IT
CSE
ECE

And i have one text item name is COUNT.

how to show the total number of records in Text item .

View 10 Replies


ADVERTISEMENT

Forms :: Records Not Displaying In Specific Text Item

Feb 14, 2012

I have for example two text items(number of records to display is set to 9). What I want is when i go to studentprofile block, it should automatically shows his subjects that are already taken up. the first text item is for 1st semester subjects and the other for 2nd semester.

here is the structure of my subjsec table:

ID number(1)
subj_code varchar2(10)
day varchar2(10)

and for subjects table:

subj_code varchar2(10)
description varchar2(50)
units number(1)
semester varchar2(10)

I restricted subjects that are in 1st sem. So i did something like this in my

DECLARE

CURSOR studgrade_cur IS
SELECT g.stud_id, g.grade, g.subj_code, s.description, s.units, s.semester
FROM studgrades g , subjects s
WHERE g.subj_code = s.subj_code
AND g.stud_id = :Studentprofile.student_id;

[Code]....

View 32 Replies View Related

SQL & PL/SQL :: How To Show Total Number Of Department

Apr 19, 2013

how to show total number of department with their department name assign to employee table.

View 2 Replies View Related

Forms :: Number Of Records Displayed In List Item Is More Than 1

Dec 28, 2010

Actually m working on oracle 10g forms. I have a list item in which no. of records displayed is 10. I am populating this list item through a record group. I want when user select a value from first record then he should not be able to select the same value in further record of that list item.

View 12 Replies View Related

Creating A View To Show Employee Names / Age And Total Number Of Projects Assigned

Apr 14, 2009

I have following tables:

EMPLOYEE (E-Number, Name, Department, age)
ASSIGNMENT (E-Number, P-Number )
PROJECT( P-Number, Project, Manager)

Create a view to show employee names, age and total number of projects they are assigned to

View 2 Replies View Related

SQL & PL/SQL :: Update Column With Total Number Of Records

Apr 3, 2012

Table : Customer

Cust_idNameid
227ABC1
227ABC2
227ABC3
228XYZ1
228XYZ2
228XYZ3
228XYZ4

In one oracle table (Customer) we have multiple cust_id based on that, we want to populate id column as cust_id record count.

I have id column right now null and want result same as above.

View 1 Replies View Related

Forms :: Is There Text Changed Trigger With Text Item Function

May 5, 2010

Is there text changed trigger with text item function like when_list_changed trigger of list item?

View 7 Replies View Related

Forms :: MS Word Rich Text Format In Text Item

Apr 17, 2012

Can I use rich text item on oracle form10G with some simple features like BOLD, UNDERLINE, ITALIC and if possible one more feature like spell check.

I Google my requirement, but mostly I found win word attachment. Further more if I can save this type of data in field then how can I print in report.

View 3 Replies View Related

Forms :: Filter Hard Coded Values In List Item (Tlist) Based On Value Entered In Text Item

May 22, 2010

I have 2 items in my form:

1) Text Item
2) Tlist

Upon form load, TList will be populated with predefined item. The behavior i am trying to achieve is to have a text item so user could entered specific text which will then filter the values in TList .

View 1 Replies View Related

SQL & PL/SQL :: Export Large Number Of Records From Select Into Text File

Feb 9, 2011

I need to export large number of records from select into the text file. It's about 2milion records.I can do it by PLSQL (see below) where executing of process takes time too much. How to export to text file faster?

DECLARE
fileid UTL_FILE.file_type;
BEGIN
fileid := UTL_FILE.fopen ('VRS_CEM', 'cust.txt', 'W');
UTL_FILE.put ( fileid, 'IMSI|MSISDN|CONTRACT');
UTL_FILE.NEW_LINE(fileid);
[code]....

View 8 Replies View Related

Forms :: Show Increasing Digit 1 To 100 In Text Field After Pressing One By One

Aug 26, 2013

the code for show increasing digit 1 to 100 in a text field after pressing a button 100 times?

View 26 Replies View Related

Forms :: How To Get Total Records And Amount

Jul 16, 2013

I've a form that allow the user to enter information & save it. in the form there is text_item called AMOUNT with multiable records.

I want when the user press SAVE button, a popup message shows the number of records enterd & total amount in all records.

EX:
AMOUNT
1000
200
3000

After clicking Save button a popup message shows ( you enterd 3 records & 4200 $ ) OK ? Cancel?

this my code in WHEN-BUTTON-PRESSED trigger

if :amount IS NOT NULL THEN
declare
cnt_record number := 1;
cnt_amount number :=:amount;
begin
go_item('amount');

[code]....

BUT !! when I test the form nothing happened.

View 5 Replies View Related

Forms :: How To Get Total Number Of Record In Form

May 20, 2011

how to get total number of record in form

View 3 Replies View Related

Forms :: Verification Of Item Text?

Mar 19, 2013

I want to make a verification of an item text ,the user must enter a number of length 4. So I created a text item :number(4). and in when-validate-item trigger of this item ,I put this

if length(:block.empno) != 4 then
message('this item must containonly 4 digit');
end if;

=> the problem, when the user entered "0123" ,it should be acceptable !! but this is not the case ...

View 12 Replies View Related

Forms :: How To Set Text Item Transparent In 6i

Dec 21, 2011

I am having Forms with background image on the canvas. now my problem is, how can i set a text item to be transparent so that the background image can be seen as clear as when there is no text item on it.

View 6 Replies View Related

Forms :: Pre-text-item Trigger?

Nov 17, 2008

In my form, for an item there is code for pre-text-item trigger. In query mode when i go to next record, previous record etc, whether this trigger gets fired? In other forms it is getting executed. Only in this form it is not getting executed. What should be reason for not executing this pre-text-item? Only this item is enabled and cursor is there.

View 9 Replies View Related

Forms :: Key Press In Text Item

Oct 9, 2010

A form with two text fields text1 and text2. Now i want to enter text value in the text1 field and subsequently this value entered into text2. i.e if i want to press x in text1 it also in the text2. if i want to press y in text1 it also in the text2. and so on without using enter key.

View 3 Replies View Related

Forms :: Clearing The Text Item

Jun 26, 2013

I am working on oracle form to build a login page and i have successfully completed it. But to make it more perfect i want to clear the text_item in which the username and password is entered. i have even raised the alert as well but after closing the alert i want to clear the text item .

View 3 Replies View Related

Forms :: Filling A TEXT-ITEM?

Jun 21, 2010

I`m new with Oracle Forms. I have the following trigger WHEN-BUTTON-PRESSED :

DECLARE
BEGIN
IF :SEARCH.SBOX is not null then -- (search text item)
IF :SEARCH.LIST45 = 'ERPLINK' THEN --(a drop down list)

[code]...

What do I want is the following thing :I have a text box :SEARCH.SBOX in which I write a number.When I press the button which will execute that trigger above, I want that the value from :SEARCH.SBOX, after the form will go to enter-query mode tofill up another text_item :CUSTOMERVIEW.ERPLINK with same value and execute_query(this text item is in master-detail form).

View 3 Replies View Related

Forms :: Retrieve Total Number In Details Block?

May 21, 2011

I am working on form which consist of two block, now i need to know total record in detail block, but in form structure i have multiple details entry aginst 1 master entry and after going for next master entry the details of privious master entry are going for posting that's why i am unable to use the currnt_record function. function to retrive the total number of records in details tab.

View 2 Replies View Related

Forms :: A Text Item Key Stroke Interceptor

Mar 13, 2010

Like vb 6.0 or vb.net in textbox's change trigger fires...when we start typing in the text boxes instantly. i want exactly this feature in forms how to do this.

I also got answer from some-body that it can be achieved by using java beans. i want the procedure of doing this or the sample

.fmb file and .jar file.

View 3 Replies View Related

Forms :: Text Item Content Disappear

Mar 11, 2010

I have data Block with many Items, text item content disappear after when mouse down trigger fire on text item in the same block!!!!!!!!!

View 1 Replies View Related

Forms :: Blinking Text Item In Oracle 6i

Sep 3, 2013

I have one database text field in oracle forms 6i and its color will change dynamically by using visual attribute.But actual my requirement to blink this text field by red color when value matches.

View 1 Replies View Related

Forms :: Dummy Background Text In Item?

Jul 3, 2012

i want to display dummy background text in one of the item of data block. is it possible is forms 10g.

for ex: i have lov on one item with WHEN MOUSE CLICK trigger.when u click mouse in that item lov popups.

so for user to understand is just want to display dummy text as CLICK HERE FOR LIST in item's background or something like disable text.

View 3 Replies View Related

Forms :: Changing LOV Based On Some Other Text Item?

Apr 18, 2013

I got a required to show LOV or list ... based on some value in other column. suppose in column A has value is A1 then column B should show A11, A12 , A13 and if Column A has value C then cloumn B should show C11, C12 ... etc//

View 2 Replies View Related

Forms :: Checking To See If A Text Item Is Empty

Aug 8, 2010

I was wondering can i check if a text item in another block is empty when a user try to create a record using a button in another block.

/*creating a program that will check to see if the customer id in the customer block is null it will then display the the stop alert and tell the user that he/she cant create a new order without having a selected a customer*/

--this is the block_item im checking to see if it null
IF (:customer.c_id) = NULL THEN
DISPLAY_ORD_STOP_ALERT;
GO_ITEM('CUSTOMER.C_ID');
[code]....

View 5 Replies View Related

Forms :: Changing Text In A Display Item

Dec 20, 2010

I have text in a display item on my Oracle Form. When my user hovers over the text with my mouse I want it to show my user that the text is active. The text may change color(no tool tip).

Is this possible?

Environment: Client / Server

View 3 Replies View Related

Forms :: Font Space For Text Item Is Not Working

Mar 9, 2013

I have one text item where i inserted some text . i want to change at run time the text space by using Font_spacing property . This thing is happen by using a push button(trigger when button pressed ). but after clicking the button this is not working.

View 1 Replies View Related

Forms :: Change Color Of Text Item Using Timers

Feb 23, 2010

How can I change the color of a text item in Oracle forms using timer for every 500 milliseconds? The text must appear to be blinking.

View 3 Replies View Related

Forms :: Text Item With Long Data Type?

Sep 6, 2011

I have a form with an item with "datatype=long". when I am typing in "Arabic" or "Persian" it break the text before line ends.but when I type in English "text" go to end line(in other words line fills to the end) and then breake to next line.It show that the problem is LANGUAGE.

nls_lang=AMERICAN_AMERICA.ar8mswin1256
Regional and language/regional option=Arabic(U.A.E)
in the block/item property : wrap_style= word ----multi_line=yes

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved