Subject | Re: [firebird-support] Execute statement |
---|---|
Author | Paul Vinkenoog |
Post date | 2003-11-27T19:00:54Z |
Hello,
place the second apostrophe at the end of the statement to be
executed, i.e.
execute statement
'select numf1 from my_table where id=1 into :my_numf';
?
Greetings,
Paul Vinkenoog
>> After reading release notes, I try to use this nice feature.I haven't yet used EXECUTE STATEMENT myself, but shouldn't you
>> A line from my test sp:
>> EXECUTE STATEMENT 'SELECT NUMF1 FROM MY_TABLE WHERE ID=1 '
>> INTO :MY_NUMF;
>>
>> But it doesn't work. MY_NUMF don't get the value.
>> Is it a correct operation?
place the second apostrophe at the end of the statement to be
executed, i.e.
execute statement
'select numf1 from my_table where id=1 into :my_numf';
?
Greetings,
Paul Vinkenoog