Greg,

As Philip said, piece the statement together. I usually write:

cMySelect = [SELECT ... ]
cMyFrom = [FROM SomeTable LEFT JOIN ... ]
cMyWhere = [WHERE SomeCondition ... ]
etc.

cMySQL = cMySelect + cMyFrom + ...
=SQLEXEC(nConnectionHandle, cMySQL, [TempCursor])


>Is there a limit to the size of SQLExec Statement. I have a DB2 table that needs to be updated from VFP. The Datatypes are different in DB2/OS390 than on VFP so I have to do some conversions. There are 32 columns on DB2/OS390 and 34 columns on VFP. When I write the SQLExec Statement it appears to reach a limit on the size of the Statement (Due to the number of columns). Is there a way around this??? Remote view doesn't appear to work because of differences between Data Types.
>
>Greg