Auto Increment Field

[Ruslan Zasukhin]

On 5/7/07 6:56 AM, "Brandon Warlick" <bwarlick at sunbelt-graphics.com> wrote:

Hi Brandon,

> I need a ULONG field that will auto increment starting with a number that I
> specify and that will not re-use numbers.
> 
> Example:
> 
> Add record ID = 1
> Add record ID = 2
> DELETE RECORD 2
> Add record ID = 3
> DELETE record 1,2,3
> Add record ID = 4
> 
> Any ideas?

You need implement this logic self.

May be using stored procedure or triggers.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]