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
Previous
Next
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