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


Hi experts

Any command or way to change auto increment value by -1 during run time?

This command shows syntax error

ALTER table diary alter COLUMN id autoincr NEXTVALUE 5



Nadeem Iqbal

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