>Nadya,
>
>I need something that is not interactive, just a class or procedure to return a string to use in the WHERE clause
>
>Thanks

Well, I wrote a user interface for our system, which allows users to specify thier selection's criteria and this application returns Where clause, JOIN expression, FieldList, etc. It has Error Handler Logic incorporated. This application was started by my colleague, and basically, only user interface part belongs to me (I've made lots of classes, designed quite complicated form, etc.) This application has several layers and the main and most desirable feature of it, that it allows to save user's configuration in a MetaFile.

The form could be run in Propmt/Design modes or in run mode, where it just returns where expression for the given configuration...

Basically, the classes I designed for this application, may be re-used in another similar like applications with completely different tables structures and if, for example, I would receive different set of tables and different request for user's criteria screen, I probably can create this application (using all other layers too) in less than two weeks, since all classes and components are already written...

You can check some related stuff at http://www.ideaxchg.com/ix08/d8/00000026.htm (see all VFPUtils stuff).

>
>Rex
>
>>>Nadya,
>>>
>>>No, what I am looking for is a utility to navigate the Relation objects in the DBC and return a string of all tables and fields necessary to place in the WHERE clause of a SQL statement given all necessary tables.
>>>
>>>Thanks
>>
>>
>>Sorry, don't know about this one. But are you sure, Query Builder (or View Designer) could not help you?
>>
>>
>>>
>>>>>George,
>>>>>
>>>>>What I am looking for is a utility to help create SQL statements.
>>>>>
>>>>>Any ideas?
>>>>>
>>>>>Rex
>>>>
>>>>Would query or View Designer in VFP be suffiecient? If it's a view, you can create draft in View Designer, then modify with EView (available here for Download).
>>>>>
>>>>>>>All,
>>>>>>>
>>>>>>>I am looking for a utility which returns a string to be used in the WHERE clause of a SQL statement given a list of tables in a database. I think it can be done from the relation objects in the DBC.
>>>>>>>
>>>>>>>Has anyone seen/written anything like this?
>>>>>>>
>>>>>>>TIA
>>>>>>>
>>>>>>Rex,
>>>>>>
>>>>>>CURSORGETPROP() with SQL as the property will return the complete SQL statement. From there it shouldn't be too hard to parse out the WHERE clause.