Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Moose Taylor
  Where is Moose Taylor?
 Oxford
 United Kingdom
 Moose Taylor
 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: 33737 # Views: 3 # Ratings: 0
Version: Visual FoxPro 8 Category: Forms
Date: Tuesday, December 02, 2003 5:47:12 PM         
   


> > To be honest I'd just lock the table, get the reccount()+1, store that as my Id, write the record, release the table.
> >
> > What d'ya think?
> >
> > John Taylor MCP
> > (You can't polish a turd)
>
> Which would work fine....But
> If you get a number as you ID and start to create a record, then I come along and create a record so I alos get an ID number.
>
> If you now decide to undo .... How can you rollback as you can't reset your reccount to your number as I have used the ID numbers after you.
>
> I think that this was question. However, if I mis-understood.....
>
> Jez


John Taylor MCP
(You can't polish a turd)

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