Subject | Building a statement at runtime |
---|---|
Author | paolopf |
Post date | 2002-06-18T09:27:37Z |
Hi list,
I'm Paolo and I've to solve this problem: in a procedure I've to make
and insert procedure knowing the field to update only at runtime.
So I've created some strings:
C0 = '' final string
C1 = 'INSERT INTO PIANIF(MINUTI, '
C2 = 'CLV2) ', the variable field
C3 = 'VALUES(1, '
C4 = ''00003'')' the field value.
I recursively change C2 & C4 and format with GenerateFormattedName,
getting C0, but when I try to execute the statement, writing CO; (
INSERT INTO PIANIF(MINUTI, CLV2) VALUES(1, '00003') ) the compiler
generates an error.
Anyone can help me?
Thanks
Paolo Fenelli
I'm Paolo and I've to solve this problem: in a procedure I've to make
and insert procedure knowing the field to update only at runtime.
So I've created some strings:
C0 = '' final string
C1 = 'INSERT INTO PIANIF(MINUTI, '
C2 = 'CLV2) ', the variable field
C3 = 'VALUES(1, '
C4 = ''00003'')' the field value.
I recursively change C2 & C4 and format with GenerateFormattedName,
getting C0, but when I try to execute the statement, writing CO; (
INSERT INTO PIANIF(MINUTI, CLV2) VALUES(1, '00003') ) the compiler
generates an error.
Anyone can help me?
Thanks
Paolo Fenelli