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.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.