>>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 ?

Yes, I copied my config.fpw and foxuser along with everything else.

I started tracing through the code, getting to the passed view parameters that returned zero records. When I took out debugging code in the requery, it started working again. That's odd because if Requery() is to blame, the other view shouldn't have worked either...

Pencilling this one as 'mysteriously resolved' and hoping it doesn't mysteriously break again.