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

Rex

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