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'

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Calling scanner Driver from Developer Form
Next Topic: Oracle Form Question
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 11:25:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.