Hello,

Ex.
Table A
Id (AutoInc)
Description

Id = 1 / Description = Test
Id = 2 / Description = Test2

I want to know the next Id number in my table without an insert. In my example it will be 3. I want to reserve (without an insert) Id number 3 because someone else can also ask the next Id number. In that case it must be id number = 4, because you've got Number 1 and 2 in the table and number 3 is reserved.

How can I do that ?

Thanks.

Nico Speleers
Analyst





Carfac bvba

[Beschrijving: Beschrijving: Beschrijving: CarfacAS (klein)]<http://www.carfac.be/>Driving on experience


Ambachtstraat 8 | 9700 Oudenaarde
Tel. +32 55 23 00 00 | Fax +32 55 31 00 95
nico.speleers@...<mailto:nico.speleers@...> | www.carfac.be<http://www.carfac.be/>

[Facebook]<http://www.facebook.com/groups/120709181286476/>[LinkedIn]<http://www.linkedin.com/company/hdc-software-nv>[Twitter]<https://twitter.com/carfacbvba>






[Non-text portions of this message have been removed]