OraFAQ Forum: Forms » how i can assign multiple values to tabuler text item

Home » Developer & Programmer » Forms » how i can assign multiple values to tabuler text item

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how i can assign multiple values to tabuler text item [message #252223]

Wed, 18 July 2007 03:09

hussienburhan
Messages: 28
Registered: July 2007

Junior Member

HI
IM PROGRAMMING ONE FORM AND I PUT THERE TABULER TEXT ITEM

I WANT ASSIGN 63 VALUES TO THIS TEXT ITEM ONE BY ONE BY CODE I MEAN PUT FIRST VALUE IN THE FIRST TEXT ITEM ROW THEN SECOND TO THE SECOND TEXT ITEM AND LIKE THIS UNTIL I REACH TO THE LAST

I MAKE LOV PUT I CAN ASSIGN ONE VALUE BY ONE VALUE EACH TIME DOUBLE CLICK ON THE TEXT ITEM ASSIGN ONE VALUE THEN DOUBLE CLICK ON THE SECOND ROW PUT MY BOSS WANT ASSIGN ALL VALUES 63 FROM ONE CLICK ON BUTTON

Report message to a moderator

Re: how i can assign multiple values to tabuler text item [message #252224 is a reply to message #252223]

Wed, 18 July 2007 03:14

azamkhan
Messages: 557
Registered: August 2005

Senior Member

You can do this by using a loop. I mean hold the 63 values in a control block and then assign these values programatically by using a loop.

Regards,
Azo Khan

Report message to a moderator

Re: how i can assign multiple values to tabuler text item [message #252292 is a reply to message #252223]

Wed, 18 July 2007 08:58

hussienburhan
Messages: 28
Registered: July 2007

Junior Member

hi
azamkhan

thank u alot

can u please write to me code small code that i can use in my forms cooox my boss waiting Razz

thank u alot

Report message to a moderator

Re: how i can assign multiple values to tabuler text item [message #252474 is a reply to message #252292]

Wed, 18 July 2007 23:41

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Algorithm for inserting bulk records in tabular table:

START OF PROGRAM

send navigation to tabular table
send cursor to first record

Start Loop

Assign the item values to the first row items of the table.

IF Not on Last Record THEN
Next Record
ELSE
EXIT
END IF

END LOOP

END OF PROGRAM

Regard,
Azam Khan

Report message to a moderator

Re: how i can assign multiple values to tabuler text item [message #252478 is a reply to message #252223]

Thu, 19 July 2007 00:02

hussienburhan
Messages: 28
Registered: July 2007

Junior Member

Mr Azam Khan Thank You Very Much
I know im asking to much but really im biggner, i know alittle bit in oracle but plsql i do not know to much what is the code for these

START OF PROGRAM (u mean procedure header)

send navigation to tabular table (How I can Send Navegation)

send cursor to first record ( How Can I send )

Assign the item values to the first row items of the table(how i can make this i will call all values with select statment select x_value into y_value from mytable
y_value this what must be its datatype

sorry but really i wish i can find the solution thank u very much

Report message to a moderator

Re: how i can assign multiple values to tabuler text item [message #252479 is a reply to message #252478]

Thu, 19 July 2007 00:08

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Mr for this read the concern books of Oracle like Oracle Corporation's Book Forms II for help.

Report message to a moderator

Re: how i can assign multiple values to tabuler text item [message #252523 is a reply to message #252223]

Thu, 19 July 2007 02:01

hussienburhan
Messages: 28
Registered: July 2007

Junior Member

HI
HIS I WILL READ OFCOURSE BUT THE PROBLEM IS THAT NOW MY BOSS ASK AND I MUST FINSH THE WORK I NEED IT IN THE NEAREST TIME PLZ HELP ME I WILL BE SO THANKFULL

Report message to a moderator