Hi!

It does not matter. Did you got the idea? Below is a VB sample:

strSQL = "SELECT ... ; " + chr(13) + chr(10) + _
"FROM ... ; " + chr(13) + chr(10) + _
...

Just make a string that looks like VFP command span to several lines using semicolon and line feeds:

SELECT ... ;
FROM ... ;
WHERE ... ;
...

One line could not be longer than 256 characters (that is a limitation of VFP). The entire command line could be much longer, but it just require to be span to several lines of code.

HTH.

>Thanks for the help but it's not really what I'm looking for, as the code itself is not written in VFP, it's either VB or VC.
>
>I am using the ADO classes to access a VFP database from these languages and the VFP OLEDB provider is what appears to be causing the error.
>
>I know it's not really a VFP issue, more of one with the OLE DB provider, but I couldnt think of anywhere else to ask !
>
>Thank anyway though.