Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: Rob Vleeschhouwer
  Where is Rob Vleeschhouwer?
 Leeuwarden
 Netherlands
 Rob Vleeschhouwer
 Tags
Subject: RE: Primary key
Thread ID: 104515 Message ID: 104550 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, August 17, 2006 2:22:12 PM         
   


> > Is it possible to combine two fields for a primary key.
> > In a orderform an articlenumber can be used twice, or more.
> > So I will combine it with the field amount(m2). Making simple this two fields as primary key doesn't work.

> >
> > PKs should not have intelligence. You should be using surrogate PKs so why not just go with an identity column?
> >
>
> I had the same idea, but it can happen that the user must use a new record.
> No problem to make a hotkey with 'append blank'. But then I have to fill that
> identity column with, lets say max(nmax,identity)+1
> Then comes VFP with an error about an unsaved record.
>
> Rob
>
> >
> > Regards,
> > Marcia G. Akins
> > Tightline Computers, Inc.


What you use when you get and send data?
CA, RV or SPT? With CA you could easily get the Identity column back with RV or SPT you must do some requery after you TableUpdate() RV or use INSERT ... in SPT.

Borislav Borissov



ENTIRE THREAD

Primary key Posted by Rob @ 8/17/2006 11:15:56 AM
RE: Primary key Posted by Bert Murillo @ 8/17/2006 11:27:43 AM
RE: Primary key Posted by Rob @ 8/17/2006 12:01:10 PM
RE: Primary key Posted by Bert Murillo @ 8/17/2006 12:45:03 PM
RE: Primary key Posted by Borislav Borissov @ 8/17/2006 11:36:23 AM
RE: Primary key Posted by Rob @ 8/17/2006 11:59:13 AM
RE: Primary key Posted by Borislav Borissov @ 8/17/2006 12:36:46 PM
RE: Primary key Posted by Marcia Akins @ 8/17/2006 12:29:32 PM
RE: Primary key Posted by Rob @ 8/17/2006 2:12:04 PM
RE: Primary key Posted by Borislav Borissov @ 8/17/2006 2:22:12 PM
RE: Primary key Posted by Koen Piller @ 8/17/2006 12:56:59 PM