>Hi All,
>
>Currently I am writing a VFP program that involve SQL command / query to process the data. In the development / project manager, it worked fine and fast. However after compilation to exe file, it run very slow on the same computer when it come to query.
>
>Is there anyone know the reason?
>
>Thanks very much for your help in advance.
The difference may be in various SET settings, particularly SET ANSI and SET DELETED if you're using VFP tables and running against the same tables in both cases.
If it's not broken, fix it until it is.
My Blog