>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.