Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
RE: THE "RULE" FOR PRIMARY KEY FIELDS
 From: Andy Kramek
  Where is Andy Kramek?
 Westminster Circle, Akron
 Ohio - United States
 Andy Kramek
 To: Mike Yearwood
  Where is Mike Yearwood?
 Toronto
 Canada
 Mike Yearwood
 Tags
Subject: RE: The "Rule" for Primary Key Fields
Thread ID: 115198 Message ID: 119261 # Views: 36 # Ratings: 0
Version: Not Applicable Category: General VFP Topics
Date: Sunday, January 21, 2007 7:13:22 PM         
   

> You use a function called NEWID, do you not? The corresponding function from the "mainstream" MS SQL Server produces a GUID.

No I do not, and have not used such a function in VFP since it fell into line with other databases in providing auto-incrementing integers in Version 8.0. I have never used anything other than native generation of PKs in any other database that I have ever worked with.

As for the function from SQL Server it has to be called explicitly - either from a trigger or in code. It is not a database engine function which is the whole point.

> The typical answers for many things are wrong, depending on perspective. Having the server generate PKs takes time. An army of client or middle tier CPUs can generate PKs and free the server up for more important tasks. Further the client or middle tier can produce a complete set of hierarchically related records and the server need do nothing, but store them.

Clearly you see things differently from me and there is no point in continuing this discussion. Your position is that the fact that the engine generates integer PKs is irrelevant, mine is that it is extremely relevant.

Fine, you do it your way and I will do it mine.

Regards
Andy Kramek
Microsoft MVP (Visual FoxPro)
Tightline Computers Inc, Akron Ohio, USA



COMPLETE THREAD
The "Rule" for Primary Key Fields Posted by Ken Murphy @ 12/6/2006 12:53:31 AM
RE: The "Rule" for Primary Key Fields Posted by Boudewijn Lutgerink @ 12/6/2006 8:32:13 AM
RE: The "Rule" for Primary Key Fields Posted by Ken Murphy @ 12/6/2006 2:11:55 PM
RE: The "Rule" for Primary Key Fields Posted by Borislav Borissov @ 12/6/2006 8:40:47 AM
RE: The "Rule" for Primary Key Fields Posted by Eric den Doop @ 12/6/2006 9:21:26 AM
RE: The "Rule" for Primary Key Fields Posted by Ken Murphy @ 12/6/2006 2:16:15 PM
RE: The "Rule" for Primary Key Fields Posted by sudhir uppal @ 1/12/2007 5:57:59 AM
RE: The "Rule" for Primary Key Fields Posted by William Sanders @ 1/12/2007 6:11:22 PM
RE: The "Rule" for Primary Key Fields Posted by Ken Murphy @ 1/12/2007 11:33:51 PM
RE: The "Rule" for Primary Key Fields Posted by Jamie Osborn @ 1/13/2007 2:05:07 AM
RE: The "Rule" for Primary Key Fields Posted by Ken Murphy @ 1/13/2007 2:20:51 AM
RE: The "Rule" for Primary Key Fields Posted by William Sanders @ 1/16/2007 9:49:00 PM
RE: The "Rule" for Primary Key Fields Posted by Ken Murphy @ 1/16/2007 10:25:38 PM
RE: The "Rule" for Primary Key Fields Posted by William Sanders @ 1/16/2007 10:25:30 PM
RE: The "Rule" for Primary Key Fields Posted by Terry Thurber @ 1/15/2007 12:41:55 AM
RE: The "Rule" for Primary Key Fields Posted by William Sanders @ 1/16/2007 9:50:14 PM
RE: The "Rule" for Primary Key Fields Posted by Terry Thurber @ 1/17/2007 7:17:35 AM
RE: The "Rule" for Primary Key Fields Posted by William Sanders @ 1/16/2007 9:58:37 PM
RE: The "Rule" for Primary Key Fields Posted by Terry Thurber @ 1/17/2007 7:44:55 AM
RE: The "Rule" for Primary Key Fields Posted by Eric den Doop @ 1/16/2007 10:56:36 PM
RE: The "Rule" for Primary Key Fields Posted by William Sanders @ 1/16/2007 11:20:56 PM
RE: The "Rule" for Primary Key Fields Posted by Terry Thurber @ 1/15/2007 1:29:36 AM
RE: The "Rule" for Primary Key Fields Posted by Ken Murphy @ 1/15/2007 9:56:37 PM
RE: The "Rule" for Primary Key Fields Posted by Mike Yearwood @ 1/18/2007 12:29:44 PM
RE: The "Rule" for Primary Key Fields Posted by Ken Murphy @ 1/18/2007 1:37:31 PM
RE: The "Rule" for Primary Key Fields Posted by Mike Yearwood @ 1/19/2007 1:58:58 AM
RE: The "Rule" for Primary Key Fields Posted by Ken Murphy @ 1/19/2007 3:41:03 PM
RE: The "Rule" for Primary Key Fields Posted by Andy Kramek @ 1/20/2007 7:12:23 PM
RE: The "Rule" for Primary Key Fields Posted by Mike Yearwood @ 1/20/2007 8:05:23 PM
RE: The "Rule" for Primary Key Fields Posted by Andy Kramek @ 1/20/2007 10:32:40 PM
RE: The "Rule" for Primary Key Fields Posted by Mike Yearwood @ 1/21/2007 4:40:22 PM
RE: The "Rule" for Primary Key Fields Posted by Andy Kramek @ 1/21/2007 7:13:22 PM
RE: The "Rule" for Primary Key Fields Posted by tushar @ 1/22/2007 6:02:17 AM
RE: The "Rule" for Primary Key Fields Posted by Andy Kramek @ 1/22/2007 12:15:08 PM
RE: The "Rule" for Primary Key Fields Posted by tushar @ 1/23/2007 8:26:36 AM