>>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.
>
>
>The string literal can not exceed 256 chars,
>Try to put this in TEXT ENDTEXT block
>
>TEXT TO cSqlInsert NOSHOW PRETEXT 15
> insert into Mytable
> (fld1, fld2, fld3)
> values
> (?MyTable.fld1, ?MyTable.fld2, ?MyTable.fld3)
>ENDTEXT
>
>
>BTW that way is more readable :-)
You are probably right. But in my case the string " insert ...." is created with the TEXT TO / ENDTEXT while scanning all fields of the table. So the resulting expression is very long. I am a little at loss right now as to how to change it. Thank you for your help.
"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