Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Probelm with AutoInc Field -- Migrate from DBISAM
Tue, Nov 6 2007 5:30 PMPermanent Link

"Jianfei Xu"
Hi, Tim

I migrate the table from DBISAM with AutoInc field as primary key field. It
looks like the new record still start generate the ID from 0, not count any
previous records, cause duplicate primary key error.

Jianfei

Tue, Nov 6 2007 5:39 PMPermanent Link

"Jianfei Xu"
Hi, Tim

I Checked seed value from EdbManager, It is right. However, when I insert
new record, it starts with 1 even inside of EdbManager.

Jianfei

Tue, Nov 6 2007 5:50 PMPermanent Link

"Jianfei Xu"
Hi, Tim

I also found the seed value not correct either when some of records already
deleted, say ID field value is 3,4,5, ..., then seed value is 0.

Jianfei

Wed, Nov 7 2007 1:54 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Jianfei,

<< I migrate the table from DBISAM with AutoInc field as primary key field.
It looks like the new record still start generate the ID from 0, not count
any previous records, cause duplicate primary key error. >>

Are you using the latest 1.05 B2 migrators ?  It works fine here.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image