INSERT with macro substituion does not work 1

[Koen Piller]

Hi,

I am stumbling over a insert command with macrosubsitution:

cInsert = [insert into myTable(field1,field2) values ("newval1","newval2")]
&cInsert

will result in an error: command contains unrecognized phrase/keword
Where as

insert into myTable(field1,field2) values ("newval1","newval2")

works fine.
What should I possibly correct to make this macrosubstitution work?

Thanks for replying,
Jockey2

 

[Mike Gagnon]

The marcro substitution you posted works for me. I assume this isn't the exact line of code that is giving you the problem. It sounds like a syntax problem.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
ReFox XI (www.mcrgsoftware.com)

 

[Koen Piller]

Mike,

You were one hundred percent correct. Solved my syntax problem in the original code ( one "(" too much )

Thanks for moral suppport,

Jockey(2)