Hi All,

Am having a problem retrieving records from a large table via ASP/ADO; Fox via ADO seems to behave quite differently to native FoxPro.

Firstly I found that my SQL does not optimise properly in ADO, even though SYS(3054) indicates that it does. Next I tried a different way using SET FILTER TO which again works fine in native VFP but the same code in a Stored Procedure called from ADO simply seems to ignore the SET FILTER TO command. Any ideas?

One difference I have found is that in native VFP the default is SET ANSI OFF while in ADO the default is SET ANSI ON, I wonder if there are other SET commands which I need to change?