Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread AutoInc field with minimum value
Thu, May 8 2008 5:48 AMPermanent Link

S Morgan
I want to use an AutoInc field with a minimum value of 1000.
Is there a way that DBISAM will start numbering at 1000 without specific code instructions?

Thanks,

Stephen
Thu, May 8 2008 6:04 AMPermanent Link

Jan Ferguson

Data Software Solutions, Inc.

Team Elevate Team Elevate

Stephen,

You can set the value using DBSys via the "Last Auto-Inc Value" field.
Simply alter the table and enter 999 as the Last Auto-Inc Value. The
next value generated will be 1000.

--
Regards,
Jan Ferguson [Team Elevate]


S Morgan wrote:

<<I want to use an AutoInc field with a minimum value of 1000.
<<Is there a way that DBISAM will start numbering at 1000 without
<<specific code instructions?
Thu, May 8 2008 4:57 PMPermanent Link

S Morgan
"Jan Ferguson [Team Elevate]" <jbNOSPAMfergusonATgmailDOTcom> wrote:

Stephen,

You can set the value using DBSys via the "Last Auto-Inc Value" field.
Simply alter the table and enter 999 as the Last Auto-Inc Value. The
next value generated will be 1000.

--
Regards,
Jan Ferguson [Team Elevate]


S Morgan wrote:

Jan,

That works great.
I also could do it with AlterTable.
Thanks,

Stephen


<<I want to use an AutoInc field with a minimum value of 1000.
<<Is there a way that DBISAM will start numbering at 1000 without
<<specific code instructions?
Image