>>>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.
Can you post the longer code that is failing and the exact line of the failure?
If it's not broken, fix it until it is.
My Blog