Thanks, that is exactly what I was looking for.

Pete

>In addition to what Trey said, you could use ADBOBJECTS() to load an array with all the views with a DBC. Then you could loop through the array checking what you needed with DBGetProp().
>
>>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