Home » Developer & Programmer » Forms » PLSQL TABLE
PLSQL TABLE [message #584842] Sun, 19 May 2013 12:44 Go to next message
D_ORA
Messages: 32
Registered: November 2012
Location: UK
Member
I have two blocks in Form (Forms 10g) .On the Block B2 I have populated the Company Id by using the PLSQL Table.Now I selected more than two company ID from that Block ...I just want to keep the Company ID in the Temp Field on the Block B1.which I have selected on the Block B2.Any idea how can I assign more then one Company ID to That Temp Field on B1.
Re: PLSQL TABLE [message #584847 is a reply to message #584842] Sun, 19 May 2013 13:44 Go to previous messageGo to next message
Littlefoot
Messages: 19608
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Obviously, you can not. Can you put two values into a single item? Think!

How do you "select more than two company ID from that block"? (I mean, focus can be in only one item at the moment, so ...? How do you do that? Do you use checkboxes or what?)

If you could explain what you want to do, someone might suggest another approach to the problem.
Re: PLSQL TABLE [message #584851 is a reply to message #584847] Sun, 19 May 2013 14:11 Go to previous messageGo to next message
D_ORA
Messages: 32
Registered: November 2012
Location: UK
Member
I am using the Check box on the Block B2..Over there I am selecting more
thn one company.

CHECK_BOX COMPANY_OD NAME AMOUNT
Y 1 ABC 444
N 2 XY 77
Y 3 Y 88

Now I just want to keep the Company IDs (1,3) into the Block B1 Temporary Company ID field...

Now My focus is only to keeping the Company ID in Block B1 field
C_COMPANY_ID ...
..The Block B2..I populated by using the PLSQL TABLE....What I have to do
to take the selected Company ID from B2 to temporary store on Block B1.
Thanks again for your prompt reply.
Re: PLSQL TABLE [message #584852 is a reply to message #584851] Sun, 19 May 2013 14:15 Go to previous messageGo to next message
Littlefoot
Messages: 19608
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Once again: you can't put two values into a single item.

I hoped that you'll explain what is the purpose of that form. What do you want to do with these "selected" IDs?
Re: PLSQL TABLE [message #584853 is a reply to message #584852] Sun, 19 May 2013 14:24 Go to previous messageGo to next message
D_ORA
Messages: 32
Registered: November 2012
Location: UK
Member
Yes Sir ,I know that ..But is it possible to assign it by using the PLSQL TABLE ...or any other idea I can fetch the Multiple values from Block B2 to assign it to Block B1..Company ID...Any Help will be useful.

Thanks,
Re: PLSQL TABLE [message #584854 is a reply to message #584852] Sun, 19 May 2013 14:26 Go to previous messageGo to next message
D_ORA
Messages: 32
Registered: November 2012
Location: UK
Member
how can I adjust/Modify my field on Block B1 to store Multiple Company ID...
Re: PLSQL TABLE [message #584855 is a reply to message #584852] Sun, 19 May 2013 14:31 Go to previous messageGo to next message
D_ORA
Messages: 32
Registered: November 2012
Location: UK
Member
I would like to make the voucher for selected companies on the other screen...I just like to keep the Companies IDs which I have selected for the voucher...
Can You please advice me how I modify/adjust that Block B1 Field to capable to store multiple company ids.
Re: PLSQL TABLE [message #584856 is a reply to message #584852] Sun, 19 May 2013 18:21 Go to previous messageGo to next message
D_ORA
Messages: 32
Registered: November 2012
Location: UK
Member
On the base of Selected IDs I like to execute the Function which is going to execute only when the voucher is created from the selected IDs...That's why I want to keep the track of B1 Block Company IDs...
Re: PLSQL TABLE [message #584857 is a reply to message #584856] Mon, 20 May 2013 00:09 Go to previous message
Littlefoot
Messages: 19608
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't understand what is the purpose of the first block (B1). What do you use it for? Because, you have already selected company IDs in form's second block (B1) so - why don't you use that selection? What do you expect to improve by moving these values elsewhere (i.e. block B1)?

From my point of view, you'd need a button. Its WHEN-BUTTON-PRESSED trigger would
a) create vouchers
b) execute function
for each selected ID.
Previous Topic: system date change
Next Topic: Getting size of image in forms 6i
Goto Forum:
  


Current Time: Wed Sep 17 15:18:27 CDT 2014

Total time taken to generate the page: 0.08559 seconds