LAST AUTOINC is ignored in DBISAM V3.xx?

Bill,

<< LAST AUTOINC is ignored in DBISAM V3.xx? >>

In what SQL statement ?  CREATE TABLE ? ALTER TABLE ?

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:
>>Bill, In what SQL statement ?  CREATE TABLE ? ALTER TABLE ?

Tim, I was using the following to create a table in DBSys:

DROP TABLE IF EXISTS "X_ACCTSETS";

CREATE TABLE IF NOT EXISTS "X_ACCTSETS"
(
  "ItemNo" AUTOINC,
  "OldItemNo" INTEGER,

   { . . . }

  "Tr_PolOther" MEMO,
  "Tr_PolTerror" MEMO,

PRIMARY KEY ("ItemNo") COMPRESS FULL
LANGUAGE "English (USA)" SORT "Default Order"
LAST AUTOINC 100000
);

I then opened the table and added a couple of new records (also in DBSys); the Autoinc field "ItemNo" began at 1 (not 100001). So, I surmise that either it's not supported or I'm
using it incorrectly.

Bill,

<< Tim, I was using the following to create a table in DBSys: >>

It appears to be a bug in 3.x.  I tried it with 3.30 and it exhibits the
same behavior.  The workaround is to include this statement after the CREATE
TABLE:

ALTER TABLE "X_ACCTSETS"
LAST AUTOINC 100000

--
Tim Young
Elevate Software
www.elevatesoft.com