Oracle skip numbers
From: vasilis <vasilisk_at_ics.forth.gr>
Date: Tue, 12 Feb 2008 10:53:59 +0200
Message-ID: <formr8$1kg9$1@ulysses.noc.ntua.gr>
Date: Tue, 12 Feb 2008 10:53:59 +0200
Message-ID: <formr8$1kg9$1@ulysses.noc.ntua.gr>
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. Received on Tue Feb 12 2008 - 02:53:59 CST