Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Eric den Doop
  Where is Eric den Doop?
 Houten
 Netherlands
 Eric den Doop
 To: Jez Enefer-Mills
  Where is Jez Enefer-Mills?
 Cornwall
 United Kingdom
 Jez Enefer-Mills
 Tags
Subject: RE: how to generate running id
Thread ID: 33675 Message ID: 33752 # Views: 3 # Ratings: 0
Version: Visual FoxPro 8 Category: Forms
Date: Wednesday, December 03, 2003 12:55:22 AM         
   


> Call for the ID number on update of completed record (SAVE) not on initial creation (ADD) should work just fine.
> That way if you undo you only remove the blank record from your main table.
>

IMHO, best practice is to use a number only once. If it is not stored, then.. oh well... one missing number. If a customer really needs a sequential identification number, then offer two id fields: one real unique primary id field and one 'fake' 'primary' id field in which they can enter their number manually or automatically.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts

ENTIRE THREAD

how to generate running id Posted by Manisha Sathe @ 12/1/2003 6:03:58 PM
RE: how to generate running id Posted by Eric den Doop @ 12/1/2003 6:12:45 PM
RE: how to generate running id Posted by Manisha Sathe @ 12/2/2003 4:16:41 PM
RE: how to generate running id Posted by Moose Taylor @ 12/2/2003 4:23:52 PM
RE: how to generate running id Posted by Jez Enefer-Mills @ 12/2/2003 5:22:08 PM
RE: how to generate running id Posted by Moose Taylor @ 12/2/2003 5:36:12 PM
RE: how to generate running id Posted by Jez Enefer-Mills @ 12/2/2003 5:45:02 PM
RE: how to generate running id Posted by Moose Taylor @ 12/2/2003 5:47:12 PM
RE: how to generate running id Posted by Moose Taylor @ 12/2/2003 5:51:25 PM
RE: how to generate running id Posted by Jez Enefer-Mills @ 12/2/2003 5:55:21 PM
RE: how to generate running id Posted by Eric den Doop @ 12/3/2003 12:55:22 AM
RE: how to generate running id Posted by Manisha Sathe @ 12/3/2003 10:29:26 AM