Subject Execute Statement problem with timestamp
Author Olaf Kluge
Hello,



I've a little problem with a sql statement:



s_stmmain = 'insert into ' || :s_stmtable || '(kd_id, fnr, fbeginn, fende)
values ('

|| :t_timestamp || ',' || cast(:i_fnr as varchar(4)) || ','

|| '1111' || ',' || '2222' || ')';

execute statement s_stmmain;



t_timestamp is a timestamp value and has a blank character. Now, I have test
it with quotest '''', but it does not work.



Has anyone an idea?



Thank you.



Best regards



Olaf







[Non-text portions of this message have been removed]