Home » Developer & Programmer » Forms » Dynamic specification of Table and Field
Dynamic specification of Table and Field [message #78921] Sun, 31 March 2002 21:10 Go to next message
Messages: 90
Registered: January 2001

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.

Re: Dynamic specification of Table and Field [message #78954 is a reply to message #78921] Sat, 06 April 2002 01:00 Go to previous message
rama krishna
Messages: 97
Registered: December 2001
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...
Previous Topic: Help Need In Query
Next Topic: user should not be allowed to exit the form until all the block is entered
Goto Forum:

Current Time: Fri May 24 02:00:25 CDT 2024