Information générale
Catégorie:
Codage, syntaxe et commandes
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement