| Dynamic SQL [message #80451] |
Mon, 23 September 2002 03:53  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
