As I figured out the hard way, when I mix tables in a view then I click the update criteria and mark the key and the related updateable fields. I did it once with nothing in criteria and changes are not kept. I did it once with the update fields marked but no key.... big oops, it changed every record in the table. I'm just wanting to get a new key without doing the work per new record. I think it just has to be an integer (big guess).
Gary Jeurink -----Original Message----- From: MB Software Solutions General Account [mailto:[email protected]] Sent: Thursday, August 23, 2012 12:36 PM To: ProFox Email List Subject: RE: auto increment On Wed, August 22, 2012 6:14 pm, Tracy Pearson wrote: > I believe changing a column to auto-increment is not a breaking change > with the views. I may be wrong, perhaps others have an idea. You can't have the AutoIncrement key field set as updatable, unless I'm mistaken? _______________________________________________ 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/A3F5C313878E4F57A7FAD75D4B7894F4@OwnerPC ** 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.
