Home » Developer & Programmer » Forms » populate pl sql table (forms10g)
populate pl sql table [message #484857] Fri, 03 December 2010 04:38 Go to next message
priyadmay
Messages: 3
Registered: December 2010
Junior Member
TABLE_FROM_BLOCK built-in Package is working in Forms 6i but not in Forms 10g. is there any other built -in available instead of this. how do we populate table from a block in Forms 10g?

Please help. its urgent....

Thanks in advance..


Regards,
Priya.

Report message to a moderator

Re: populate pl sql table [message #484858 is a reply to message #484857] Fri, 03 December 2010 04:53 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Well that function doesn't appear to exist in 10g so I can't find any documentation on what it does. So it'd help if you gave more details of what it does.

Report message to a moderator

Re: populate pl sql table [message #484864 is a reply to message #484858] Fri, 03 December 2010 06:27 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
See Mark Roberts' answer.

Report message to a moderator

Re: populate pl sql table [message #485281 is a reply to message #484864] Tue, 07 December 2010 04:34 Go to previous messageGo to next message
priyadmay
Messages: 3
Registered: December 2010
Junior Member
Thanks Littlefoot..

But Actually my requirement is like to find the duplicate entries in Multi record block.

Please help.

Regards,
Priya

Report message to a moderator

Re: populate pl sql table [message #485295 is a reply to message #485281] Tue, 07 December 2010 05:29 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, so do that manually (instead of via TABLE_FROM_BLOCK).

I attached a dummy form that shows how you might try to do that.

Report message to a moderator

Re: populate pl sql table [message #485789 is a reply to message #485295] Thu, 09 December 2010 22:34 Go to previous messageGo to next message
priyadmay
Messages: 3
Registered: December 2010
Junior Member
Hi Little Foot
Thanks for your help...as per this form, system will find the duplicate based on the table records. But my requirement is the table has no records, I am entering in a multi record block.

So in this case how we can find out the duplicates of the current record with previous records which is till not commited?


Regards,
Priya

Report message to a moderator

Re: populate pl sql table [message #485801 is a reply to message #485789] Fri, 10 December 2010 01:18 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Actually, it will find duplicates based on table records AND records you enter in a form. Did you test it? I guess you do have Scott's schema available, don't you?

Report message to a moderator

Previous Topic: Run form saved on network disk
Next Topic: Oracle forms
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 00:37:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.