Query results different in Dev and Exe Mode.

[Guest_imported]

I am using Visual FoxPro 6.0 SP4 as GUI development tool. Also using Access as Back End through ODBC.
While I am in desing mode, quiery results a correct, then I compile and execute program and the results are not.
Data comes from Remote Views made out of Access through ODBC.

What is the problem? Any problems during Desing and Exe mode.

 

[rgbean]

The first thing I'd do is make sure the VFP runtime files (VFP6*.dll) are the same version as your development program (VFP6.EXE). 6.08862.0 is SP4, 6.08961.0 is SP5. Next I'd make sure of the ODBC files you have installed. SP4+ requires MDAC 2.5 or higher. Go to

http://www.microsoft.com/data/

for MDAC updates and the Component Checker to verify what you have installed.

Rick