>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:
>>
This do not work. lnResult=-1
Set Textmerge On
TEXT To lcSql Noshow
Select .....
ENDTEXT
lnResult = SQLExec(gnConnHandle, lcSql,"anyfile")
=Messagebox(lnResult)
= SQLDisconnect(gnConnHandle)
Where am i wrong?