Doh! I could have sworn I had done that before.
>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
Chris McCandless
Red Sky Software