>>"Base table fields have been changed and no longer match view fields. View field properties cannot be set."<<
The root of your problem is using the "*" in the fields section of the SELECT command. I am actually surprised you can even open the view in the Command Window to BROWSE it. At the moment the view is saved the columns for the table are pulled and stored in the local view. Adding columns or removing any column will break the view. When it opens the view the columns are matched to the base table and they are out of synch. Only way around this is to not use the asterisk and code each column you want, OR use Stonefield Database Toolkit (SDT) to make changes to the tables (it fixes related views when the changes are saved). The first approach means you have to alter the views each time you add a new column and the column is needed in the view. The second approach is simpler, but means you have to own a licensed copy of SDT. Rick White Light Computing, Inc. www.whitelightcomputing.com www.swfox.net www.rickschummer.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/006d01cbb5bb$897996f0$9c6cc4d0$@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
