Home » Developer & Programmer » Forms » Give table name dynamically
Give table name dynamically [message #80584] Wed, 16 October 2002 23:51 Go to next message
Mashhood
Messages: 2
Registered: October 2002
Junior Member
I want to give table name in a query on run time in Forms 6. I use 'Forms_DDL' but it works with Insert, update , delete or DDL statements.
but i want it in Select statement.
e.g

Select ename from 'a variable'
Re: Give table name dynamically [message #80585 is a reply to message #80584] Thu, 17 October 2002 10:13 Go to previous message
Julie
Messages: 98
Registered: February 2002
Member
Build your query as a string and execute it using EXEC_SQL.
Previous Topic: Calling scanner Driver from Developer Form
Next Topic: Oracle Form Question
Goto Forum:
  


Current Time: Tue Oct 19 20:12:01 CDT 2021