UPDATE & ?

[vlukes]

So, please, help me... I want to use question mark in UPDATE (in 4GL) - for example:

...
LET text =
UPDATE qwerty SET col01 = ?, col02 = ?';
PREPARE prp01 FROM text;
EXECUTE prp01 USING 'sl01', 'sl02';
...

Fajn, so, how can I replace table name ("qwerty") by question mark (UPDATE ? SET...) ???
Thanks.

 

[PHV]

I don't think you can use a parametized table name.
Use a variable instead:
LET t = "qwerty";
LET text = "UPDATE " || t CLIPPED || " SET col01 = ?, col02 = ?";

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[vlukes]

I try it..., perfect Thanks.