>>>I'm looking for a utility that will allow basic SQL operations on .DBF files to be used by our testers..
>>>
>>>We don't use the dev env in FoxPro for applications, but use the database format and access it through VC++ and VB using Sequiter's CodeBase. In order to test our apps, we need to populate the database files with test cases. A stand-alone utility with query, modification, import and export (to/from text files) abilities would be useful. Public domain or third-party software.
>>
>>Karen, try the QueryMaker from Strategic Edge (http://www.strategicedge.com, 415-563-3755). It can be compiled into an EXE and will save your data in DBF, FP2.x DBF, Excel spreadsheet ASCII, and many other formats. You import your tables, assign the links between tables and you're ready for the user.
>>
>>I just finished making a small EXE with nothing but a login form, a menu and the Query Maker for a client.
>>
>>HTH
>>Barbara
>
>Can QueryMaker be used from within FoxPro? Sooner or later, I will be asked to make some sort of simple query builder for a user who wants more flexibility in querying data than my old forms and reports provide, but who doesn't know SQL. If Querymaker is not the appropriate tool, is there something else I should use, in order not to reinvent the wheel?

Hi Bret,
I didn't read Karen's message thoroughly :-( so Query Maker won't work for her - it doesn't populate tables, only manipulate them.

However, for your purposes it may be ideal. Query Maker is VFP code, you can compile it to VFP3 or VFP5 and then import your tables. Deleted fields you don't want them to touch (ID fields, etc.), follow the directions for setting links between parent/child tables and compile your EXE. Just add a button or menu choice. Check out the website or their ads in FP Advisor. My users like it because they never see the SQL, just the 'English' code for setting up the WHERE clauses.

Barbara