Hi,

Thanks for the help. I was using this command to get the SQL. I was really wanting to find out how to loop through all of the open views. I have been told I can use AddObjects to get a lit of views, so this looks like what I need.

Pete
>DBGETPROP(v, "View", "SQL")
>
>Returns the SELECT statement from the view.
>You can then parse this string to pull out all "?" parameters.
>
>>Hi,
>>
>>I have an application in which I have a VFP database containing lots of remote views. I now have a situation where it would be very handy to be able to iterate through the database and check the SQL for each view and if it is a specific value that I need to requery the view.
>>
>>Is there a way in VFP to do such an iteration?
>>
>>Something along the lines of:
>>
>>For Each v in TmpData
>>
>>Next
>>
>>where v would be a table or view within the database.
>>
>>Pete