Interactive queries in an executable

Hot Topic

Select question
copying file to a folder
Grid sorting
Help with expression (one more time...)?
How to set File handle in Windows XP
Error when opening Foxpro build-in database application: Open File - Security Warning
Working with field General!
SYS(3056)
Arrange the "character string" numbers in order
Error loading

Visual FoxPro

Mixing XLS and DBF tables
Vfp Converting DateTime Problem in MSSql
Lost Ability to play wav file
How to save the last used URL in VFP?
About visual foxpro
"When" firing after "Valid"
Hot key question
VPF 6: Problem sending the item from the combo to report designer
VFP multi-threaded app example now at codeplex
VFP menu bar problem

Interactive queries in an executable

Does anyone have an easy way to give experienced users a “MODI QUERY” type capability inside of an executable without programmatically building it from scratch We have a client that is experienced in FoxPro and knows how to create queries using MODI QUERY from the command box. They have quite a few of these and use them to select data by changing the selection criteria in the query designer. In an old FoxPro for Windows module of the application (running as an app), we made it easier for them to run these queries by letting them put them in a directory that we read and used to build a pick list. When they selected the query, we would execute the MODI QUERY command inside of the app for them with the selected query. We are now upgrading them to VFP 9 with an executable (for obvious security and other reasons), and this old functionality doesn’t work. Any thoughts from anyone on how we could give them some functionality this



Answer this question

Interactive queries in an executable

  • vishwanath madalgi

    Bill Frogner wrote:

    Does anyone have an easy way to give experienced users a “MODI QUERY” type capability inside of an executable without programmatically building it from scratch We have a client that is experienced in FoxPro and knows how to create queries using MODI QUERY from the command box. They have quite a few of these and use them to select data by changing the selection criteria in the query designer. In an old FoxPro for Windows module of the application (running as an app), we made it easier for them to run these queries by letting them put them in a directory that we read and used to build a pick list. When they selected the query, we would execute the MODI QUERY command inside of the app for them with the selected query. We are now upgrading them to VFP 9 with an executable (for obvious security and other reasons), and this old functionality doesn’t work. Any thoughts from anyone on how we could give them some functionality this

    There are quite a few third party products that you can build in to your app - StoneField Query, FoxFire!, QueryMaker (to name a few).

    Check them out.



  • XNA Rockstar

    Is there any chance to convince them that a 3rd party product is acceptable If so, you may have the most success with Stonefield Query, which is getting more and more widely used, not just in the VFP market.

    Tamar

  • Stéphane Beauchemin

    Thanks Tamar. I'll discuss it again with them. We are really looking for an ad hoc data harvesting tool. The creationg and formatting of the report is not the primary goal. Just something to grab selected data and dump it somewhere like and Excel spreadsheet. Again, thanks for your help.

    Bill

  • Rena

    Thanks for the ideas, Marcia. The problem we have is that our client is very strict about which third pary products they will allow in the system. The only reporting tool that is "authorized" is Crystal Reports/Business Objects, and this if not an option for the VFP knowledeable users of our software. They like going in and directly modifying the query, but this isn't an option in a VFP executable. Any other thoughts


  • Interactive queries in an executable
Answer this question