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:mbsoftwaresolutions@mbsoftwaresolutions.com]

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: ProFox@leafe.com

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.