A string literal in VFP is limited to 255 characters. You should use TEXTMERGE to easy build and maintain queries

TEXTMERGE TO lcSql NOSHOW
select table1.field1,table1.field2,table1.field3,table1.anyfieldother 
where table1.fieldx=table2.fieldy and......
ENDTEXT

lnResult = SQLEXEC(gnconnHandle, lcSql)

>I do not understand this behavior: ODBC with Oracle:
>