FoxPro Help and Support - set remote view properties after upsize

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

set remote view properties after upsize

ghj

2005-05-16, 1:24 pm

I would like to change the UPDATE CRITERIA/ WHERE CLAUSE INCLUDES to "key
fields only" for all of the remote views (created via the upsize wizard)
in the database.

Is there a way do to do this without editing each view.

Anders Altberg

2005-05-16, 1:24 pm

You can get an array of viewnames to loop through from this function
OPEN DATABASE x
ADBOBJECTS(aArray, 'VIEW')
Use the function DBSETPROP('viewname'
,'VIEW', 'WhereType', n) to modify
this view property for each view in a FOR .. NEXT loop.
-Anders

"ghj" <ghj@ghj.com> wrote in message news:K85ie.2771$BF5.2025@trndny06...
> I would like to change the UPDATE CRITERIA/ WHERE CLAUSE INCLUDES to "key
> fields only" for all of the remote views (created via the upsize wizard)
> in the database.
>
> Is there a way do to do this without editing each view.
>
>

Sponsored Links