>ok, what I'm doing is compiling a program that I have into an .APP and this runs fine without a hitch. I then re-compile it into an .EXE, into the same directory without changing a stich of code and I get an error (1811 : SQL Aggregate on non numeric expression)generated from an SQL statement.
>
>What gives? Is there some environment setting that changes between an .APP and an .EXE?
>
>If I could generate the same error when it runs as an .APP i'd fee a lot happier but I cant. Does anyone have any ideas.
>
>
>Ashley Cottle
>Assuresoft Ltd.
>AshleyC@cosworth.infotrade.co.uk

Ashley, I don't know why you don't get the error in the APP, but check the SQL in question to be sure your sum(), AVG() or other similar function is on a numeric field.

There are other differences between APP and EXE files, so it's always best to compile and test an application at regular intervals. If you need to see Debug information, run the EXE from the command window: DO MyExe.EXE

You can bring up the debugger with 'set step on' or 'set asserts on' (followed by 'assert = .f.' or the equivalent of course)

HTH
Barbara