On 1/16/2011 3:25 PM, Rick Schummer wrote: >>> "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.
SDT is well worth the money. And it really doesn't cost that much, either, iirc. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ 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/[email protected] ** 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.
