>I have a fairly complicated view that works properly when running the program within the VFP environment.
>When compiled to an EXE and all files copied to another drive, the view returns zero results.
>Other views in the EXE work properly, and manually executing views from on the new drive returns proper results.
>I've validated, packed and recompiled the database and project. Any suggestions of what/where to look to find the cause?
Are you sure that the SET ANSI and SET DELETED settings are the same in EXE and IDE ?
If it's not broken, fix it until it is.
My Blog