auto increment

Author: Gary Jeurink

Posted: 2012-08-22 at 14:07:37

Now that I've upped from fp-6 to fp-9, I want to change a few tables that

use an integer idno as a primary key to an auto increment type. The only

reason these tables need a primary key is so I can update their values

through a view. I learned that the hard way in a football data base when I

would mark 1-game as a conference game and then find that many games were

also checked also. Will it require me to go through all the tables, views,

and related forms then reset the data type? I'm not good at generating the

next higher idno from a list that is filtered. In this case I keep an admin

table that contains the next game idno to use (occasionally fails).

Gary Jeurink

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

_______________________________________________

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/A9C7A1A6137340679FE5C9FD15E3BEAE@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.

©2012 Gary Jeurink