Sequences?

Carsten Friehe rblists at carsten-friehe.de
Tue Dec 14 13:10:02 CST 2004


Hi Ruslan!

> You need make helper table to keep the NEXT ID for some table.
> Just 2 fields in this helper table
>     TableID     NextID

Ok.

> And AFAIK in Oracle sequences also use helper table.

Maybe.
 
> So you can easy write in your app
> 
>     NextIdOf( TableID ) as Integer
> 
> And use it in your app.

I think NextIdOf will be a method which get the actual value and
increments the value inside the table. That will work, I think.

Thank you!
Carsten


More information about the Valentina mailing list