What is structure of the table on ORACLE?
MartinaJ
>>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?