Jim,

It is actually the same .exe being run in two different environments (W98 desktop and VFP command window) on the same PC.
We tried to debug the problem by pasting the code into a .prg and the same results occured as in the compiled app.


>Strange all right!
>
>My only guess is that the malfunctioning runs have some commented line(s) that are not evident because of the colour-coding bug. I'd look for a semi-colon on a commented line.
>
>good luck
>
>
>>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.