>I have a form which allows user to input a combination of criteria and then I need to construct a SELECT statement in runtime using the user criteria.
>
>Initially how I solve the problem is to create a QPR file runtime by using file I/O function. Then in my program, I DO the constructed QPR file.
>
>However, It only works when I run my program under VFP. It won't work if I build an EXE because the QPR file is built in the EXE at compile time and I cannot change it in runtime.
>
>Any comments/suggestions will be highly appreciated!
>
>Thanks!

If your you are building the SQL statment to run a report, check out the third party product called Foxfire. It allows your user to build adhoc reports based on real language (not variable names) representations of the field and a whole lot more. They have done the work for you.