Dynamic specification of Table and Field [message #78921] |
Sun, 31 March 2002 21:10 |
Mahesh
Messages: 90 Registered: January 2001
|
Member |
|
|
Hellow,
I need to process records by allowing user to dynamically specify table and fields name and display the processed records in the form.
I tried using REF CURSOR. But apparently it is not allowed in the form as when i put my query with "OPEN c FOR query_string" it gives the error message saying "select" is expected.
Any help will be greatly appreciated.
Thanks
Mahesh
|
|
|
Re: Dynamic specification of Table and Field [message #78954 is a reply to message #78921] |
Sat, 06 April 2002 01:00 |
rama krishna
Messages: 97 Registered: December 2001
|
Member |
|
|
hi,
u can use set_block_property('block_name,dml_data_Target_name,'xyz');
this way u can change the table name accordingly..
or u can write a backend procedure with ref cursor and give the block source as that procedure and change the query_data_source_name in the set block property...
|
|
|