Home » Developer & Programmer » Forms » how i can assign multiple values to tabuler text item
how i can assign multiple values to tabuler text item [message #252223] Wed, 18 July 2007 03:09 Go to next message
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
icon6.gif  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 Go to previous messageGo to next message
azamkhan
Messages: 548
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
azamkhan
Messages: 548
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
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 Go to previous messageGo to next message
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


icon8.gif  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 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Mr for this read the concern books of Oracle like Oracle Corporation's Book Forms II for help.
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 Go to previous messageGo to next message
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
Re: how i can assign multiple values to tabuler text item [message #252565 is a reply to message #252523] Thu, 19 July 2007 03:15 Go to previous messageGo to next message
zameersait
Messages: 16
Registered: July 2007
Junior Member
Please refer http://orafaq.com/faq/how_does_one_iterate_through_items_and_records_in_a_specified_block
Re: how i can assign multiple values to tabuler text item [message #253173 is a reply to message #252523] Mon, 23 July 2007 01:04 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Loading data into a block MANUALLY
http://www.orafaq.com/forum/m/111031/67693/#msg_111031

David
Previous Topic: Installing Forms 5.0 and Forms 6i
Next Topic: Item, old value
Goto Forum:
  


Current Time: Sun Dec 04 14:49:29 CST 2016

Total time taken to generate the page: 0.10415 seconds