OraFAQ Forum: Forms » PLSQL TABLE

Home » Developer & Programmer » Forms » PLSQL TABLE

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

PLSQL TABLE [message #584842]

Sun, 19 May 2013 12:44

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.

Report message to a moderator

Re: PLSQL TABLE [message #584847 is a reply to message #584842]

Sun, 19 May 2013 13:44

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: PLSQL TABLE [message #584851 is a reply to message #584847]

Sun, 19 May 2013 14:11

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.

Report message to a moderator

Re: PLSQL TABLE [message #584852 is a reply to message #584851]

Sun, 19 May 2013 14:15

Littlefoot
Messages: 21823
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?

Report message to a moderator

Re: PLSQL TABLE [message #584853 is a reply to message #584852]

Sun, 19 May 2013 14:24

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,

Report message to a moderator

Re: PLSQL TABLE [message #584854 is a reply to message #584852]

Sun, 19 May 2013 14:26

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...

Report message to a moderator

Re: PLSQL TABLE [message #584855 is a reply to message #584852]

Sun, 19 May 2013 14:31

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.

Report message to a moderator

Re: PLSQL TABLE [message #584856 is a reply to message #584852]

Sun, 19 May 2013 18:21

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...

Report message to a moderator

Re: PLSQL TABLE [message #584857 is a reply to message #584856]

Mon, 20 May 2013 00:09

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	system date change
Next Topic:	Getting size of image in forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 19:07:45 CST 2025