RE: auto increment

Author: Tracy Pearson

Posted: 2012-08-23 at 12:51:56

Stephen Russell wrote on 2012-08-23:

> On Thu, Aug 23, 2012 at 12:35 PM, MB Software Solutions General

> Account <mbsoftwaresolutions@mbsoftwaresolutions.com> wrote:

> 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?

>> --------------------------

>>

> Why would you ever update a PKey? It is just a pointer.

>

Stephen,

Converting an existing field to be an AutoIncrement and that table is

already connected to a view. The view would probably have the field set as

Updateable. So, this is one of the problems that the OP was asking for.

Tracy Pearson

PowerChurch Software

_______________________________________________

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/000d01cd8157$fcd41df0$f67c59d0$@powerchurch.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.

©2012 Tracy Pearson