Very Computer

by **wong** » Sun, 09 May 1999 04:00:00

Help me guys

here is my sample code (vb 5)

let say "custid" is a autonumber field.

when I fire "data1.recordset.addnew" this field will increas by 1, right!
My problem is, when I fire "data1.recordset.cancelupdate" and I want to set
the "custid" back to the previous number so that when I add record again,
the number won't jump. How can I do that ?

Thanks in advance.

by **Doug Steel** » Sun, 09 May 1999 04:00:00

> Help me guys

> here is my sample code (vb 5)

> let say "custid" is a autonumber field.

> when I fire "data1.recordset.addnew" this field will increas by 1, right!
> My problem is, when I fire "data1.recordset.cancelupdate" and I want to set
> the "custid" back to the previous number so that when I add record again,
> the number won't jump. How can I do that ?

You can't. Autonumbers weren't meant to be "reused" once they've been
used. However, since autonumbers really are only there to be used as
unique IDs for Primary and Foreign Keys, and should never have any
meaning associated with them, that shouldn't be a problem.

> Thanks in advance.

--

Beer, Wine and Database Programming. What could be better?
Visit "Doug Steele's Beer and Programming Emporium"
http://webhome.idirect.com/~djsteele/

by **James Olse** » Sun, 09 May 1999 04:00:00

You can't the autonumber field is generated for the transaction. The reason
it can't be reused is because there can run more than one transaction at a
time and they each need and unique number which has to be generated
sequentially - so you won't be able to get a perfect sequential numbering
without gaps.

> Help me guys

> here is my sample code (vb 5)

> let say "custid" is a autonumber field.

> when I fire "data1.recordset.addnew" this field will increas by 1, right!
> My problem is, when I fire "data1.recordset.cancelupdate" and I want to
set
> the "custid" back to the previous number so that when I add record again,
> the number won't jump. How can I do that ?

> Thanks in advance.

by **Noah Bod** » Wed, 12 May 1999 04:00:00

> Help me guys

> here is my sample code (vb 5)

> let say "custid" is a autonumber field.

> when I fire "data1.recordset.addnew" this field will increas by 1, right!
> My problem is, when I fire "data1.recordset.cancelupdate" and I want to set
> the "custid" back to the previous number so that when I add record again,
> the number won't jump. How can I do that ?

> Thanks in advance.

Sorry to tell you this cannot be done. The autonumber field is designed so
there can never be the
possibility of duplicate numbers.

->N.

by **Edwin Ma** » Mon, 17 May 1999 04:00:00

Quote:> You can't the autonumber field is generated for the transaction. The
reason
> it can't be reused is because there can run more than one transaction at a
> time and they each need and unique number which has to be generated
> sequentially - so you won't be able to get a perfect sequential numbering
> without gaps.

Then are there any method to fix this tyoe of problem?? I have a date entry
program that also need to generate a auto incre. no. !!

Thanks
Edwin

Very Computer

Autonumber field

Autonumber field

Autonumber field

Autonumber field

Autonumber field

Autonumber field