Home » Developer & Programmer » Forms » Dynamic SQL
Dynamic SQL [message #80451] Mon, 23 September 2002 03:53 Go to next message
Ravi
Messages: 251
Registered: June 1998
Senior Member
hi All,
I am using a control block and i wrote a function which tells me whether a particular value is existing in a particular table or not.
For the above function i am passing tablename,fieldname,fieldvalue as parameters.
i have written code as
lv_string :='select count(*) into lv_count from '||tablename||'where '|| 'fieldname='||fieldvalue;
my problem is how to run this lv_String so that i can get the count into a variable lv_count

thanks in advance
regards
ravi
Re: Dynamic SQL [message #80453 is a reply to message #80451] Mon, 23 September 2002 08:24 Go to previous message
Eric
Messages: 78
Registered: April 1999
Member
Which version of Forms are you using?
Previous Topic: Developer2000 and Oracle8i
Next Topic: Run a form on the web - file download msg appears
Goto Forum:
  


Current Time: Sat Mar 02 09:42:18 CST 2024