We are experiencing an interesting problem and would appreciate assistance.
The problem is that a VFP 5 SQL statement, containing an EXISTS clause, behaves differently when running from a compiled application on the W98 desktop compared to a .prg or compiled application from the command window.
When running from the .prg, two fields from within the EXISTS clause are inserted into the output cursor. For example, the clause 'EXISTS (Select * from curassinv where curassinv.cinvno = curinvc.cinvno)' inserts the fields cinvno_a and cinvno_b into the output cursor. This is part of a longer SQL clause that was pasted from a form. When the complete compiled application is run from the VFP command window this error also occurs. However, when the compiled application is run from the W98 desktop, the error does not occur.
We have done the obvious and done a 'list status' from both and the status settings that are listed are the same.
All help is greatly appreciated.
TIA.