>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!
have you tried making the qpr external to the exe? (add to project but tell vfp not to include in exe)