>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 :-)