Hi Chris.

>You can use the DBGETPROP() function to get the SQL clause, adjust the WHERE portion of it, then write it back to the DBC with DBSETPROP():

Unfortunately, that won't work -- the SQL property is read-only.

There are two ways to do this:

- Open the DBC as a table, locate the view record, and replace the appropriate part of the PROPERTY memo with the new SQL SELECT statement. This is not a simple task, since the PROPERTY memo has binary information and it's very easy to damage the DBC by changing it without knowing exact how the information is stored.

- Redefine the view. If you store the view definition in a local DBC (or a copy of the DBC that's copied to a local drive), this won't cause any contention issues.

Doug