Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
AutoInc field with minimum value |
Thu, May 8 2008 5:48 AM | Permanent 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 AM | Permanent Link |
Jan Ferguson Data Software Solutions, Inc. 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 PM | Permanent 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? |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |