I've upgraded an application to VFP7 from VFP6. I'm using SQL 7 as the data engine with remote views setup to all necessary tables. I seem to be getting weird results from SELECT statements in some of my code.

For example, I have a select that is setup to query 2 views, very basic stuff with a 3 clause where, group and order. When the code is executed through the application it returns no data, yet when run through the command window it returns the expected results.

Is anyone else having similar problems?

TIA