>>Hi,
>>
>>I am getting an error a line very similar to the following. The error says "command contains unrecognize phrase/keyword".
>>
>>
>>cSqlInsert = "insert into Mytable (fld1, fld2, fld3) values (?MyTable.fld1, ?MyTable.fld2, ?MyTable.fld3)"
>>
>>
>>The list of fields is actually considerably longer. But what should I be looking at? TIA.
>
>Considerable longer? How much longer? There is a limit of 8190 characters for any command in foxpro: try
>
>
>EXECSCRIPT(REPLICATE('*', 8190))
>EXECSCRIPT(REPLICATE('*', 8191))
>
Didn't mean to ignore your input. You are right that the variables can be pretty large. But my issue was that I was assigning a long (very long) string to a literal string. And this is not allowed. Naomi's very creative solution resolved my issue. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham