Re: Oracle skip numbers

On Feb 12, 2:53 am, "vasilis" <vasil..._at_ics.forth.gr> wrote:
> Hello,
>
> When using Powerbuilder with Oracle, in some cases oracle skips numbers.
> What I mean is that when the ID column has a value of 100, instead of
> getting the next value(101) I get 102 or 103 anything but not the next. It
> updates the same row from 100 to 103 and of course as you might imagine I
> can not retrieve the row of 100. How this problem may be solved(Not updating
> the id column to a different value).
>
> Thanks in advance.

Normally a sequence is used to generate a surrogate key value, so I'm wondering why you're updating an apparent key?

You'll need to explain this MUCH better than you have to get a valid, usable response.

David Fitzjarrell Received on Tue Feb 12 2008 - 09:24:11 CST