Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: Nadeem Shah
  Where is Nadeem Shah?
 Rawalpindi
 Pakistan
 Nadeem Shah
 Tags
Subject: RE: Auto increment field
Thread ID: 143180 Message ID: 143186 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Saturday, August 25, 2007 7:40:03 PM         
   


> Hi experts
>
> Any command or way to change auto increment value by -1 during run time?
>
> Nadeem Iqbal

CREATE TABLE MyTable (nMyField I AUTOINC STEP -1, MyNextField ...)

but as Borislav aske? WHY?

An autoinc field is normally used as the primary key field and should only be used to uniquely identify a record within that table - there should be no other use. If you need the number to increment backwards, then I suspect that there is some other use you are attempting with this field. What exactly are you trying to do?

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)

ENTIRE THREAD

Auto increment field Posted by Syed Nadeem Iqbal @ 8/25/2007 7:14:13 PM
RE: Auto increment field Posted by Borislav Borissov @ 8/25/2007 7:26:32 PM
RE: Auto increment field Posted by Ken Murphy @ 8/25/2007 7:40:03 PM
RE: Auto increment field Posted by Syed Nadeem Iqbal @ 8/26/2007 4:24:49 AM
RE: Auto increment field Posted by Syed Nadeem Iqbal @ 8/25/2007 8:30:17 PM
RE: Auto increment field Posted by Marcia Akins @ 8/25/2007 9:12:34 PM
RE: Auto increment field Posted by Syed Nadeem Iqbal @ 8/26/2007 4:22:09 AM
RE: Auto increment field Posted by Andy Kramek @ 8/27/2007 1:08:07 PM
RE: Auto increment field Posted by Thomas Bähr @ 8/27/2007 5:48:07 PM
RE: Auto increment field Posted by Marcia Akins @ 8/28/2007 3:14:23 PM
RE: Auto increment field Posted by Syed Nadeem Iqbal @ 8/28/2007 6:39:17 PM
RE: Auto increment field Posted by Ken Murphy @ 8/26/2007 3:04:29 PM