Re: Oracle skip numbers
Date: Tue, 12 Feb 2008 07:24:11 -0800 (PST)
On Feb 12, 2:53 am, "vasilis" <vasil..._at_ics.forth.gr> wrote:
> 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