General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only