Re: Oracle skip numbers

On Tue, 12 Feb 2008, vasilisk_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).

This is really confusing. Can you rewrite your question? My first thought was you need to ask the database to return rownum and use that to iterate, but it isn't clear what you are doing.

-- 
Galen Boyer