VFP ODBC driver has VFP6 underlying code. See http://www.berezniker.com/content/pages/visual-foxpro/visual-foxpro-odbc-driver for details. If you need VFP9 features, you've to use VFP OLE DB provider.


>We are accessing a VFP 9 database from the web via ColdFusion. My query works in my test environment, but I am getting a SQL Expression Too Complex error when running it in the production environment. I finally identified the problem - it has to do with a limit on the number of values in the IN clause of the query. If I reduce the number of items selected, the query runs fine. However, it will not work if the number is over 24. I don't have this problem in the test environment - even with over 24 items. The db was created as VFP 6 on the production server, but we are now using VFP 9 for database changes. Is there any way to override this issue? I saw something about SYS(3055) but I don't know how to do anything with that using ColdFusion. Any way to change the db settings on the server so it works through ColdFusion (ODBC connection)?
>
>Thanks