General information
Category:
Coding, syntax & commands
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only