| is it possible to query a database using forms_dll??? [message #79548] |
Thu, 20 June 2002 22:36  |
Y.A.D.V
Messages: 4
Registered: June 2002
|
Junior Member |
|
|
Hi All,
my_stmt := 'SELECT eno,ename,joindate from tmp into('||(:blk1.item1)||','||''''||(:blk1.item2)||''''||','||''''||(:blk1.item)||')';
forms_dll(my_stmt);
is it pssible to retrieve data from database using select statement in forms_dll??..
please help me out to solve this problem..
|
|
|
|
|
|
|
|
| Re: is it possible to query a database using forms_dll??? [message #79591 is a reply to message #79573] |
Mon, 24 June 2002 04:25  |
N
Messages: 26
Registered: April 2002
|
Junior Member |
|
|
hi d,
well I have tried this myself, although i must admit i did not expect much because forms_ddl is a Data Def function eg, update, create,
SELECT is a DML Data Manipulation lang. Do you only need to populate the form with data, or are you just experimenting with FORMS_DDL. Exactly what are you trying to achieve here please, I'm rather curious ?
arios,
n.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
