I set up a parameterized view for an access 97 table. It works great if I plug the parameters in interactively, but if I set values to the variables and try to run the view, I get an error back from the ODBC driver saying "driver not capable". I'm using VFP 3.0b and the latest 32-bit ODBC drivers. If this is a shortcoming of the ODBC driver, anyone know why? I just don't understand why it doesn't work. Anyone have any workaround for that (I'd hate to have to fetch all 200,000+ records just to ultimately use 4!).
Thanks.