>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.
If it's not broken, fix it until it is.
My Blog