Is the key a numeric sequence (1001, 1002, etc...)? If so, you could do a "select count(*) from table" and add your offset to that (1000 from the example above)
Does this help? Mikey "Michael Sweeney" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > lol sorry, buttons are too close together in OE. > > Anyon ehave a sugestion on a different way of doing what I want to do? > Should be easy but i;m starting to get a headache from this (6-7 years not > doing SQL doesn't help either) > > > > <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Maybe it does in Oracle - you should check your documentation though... > > > > BTW, please post your replies to the list rather than me personally :-) > > > > > -----Original Message----- > > > From: Michael Sweeney [mailto:[EMAIL PROTECTED]] > > > Sent: 30 May 2002 15:58 > > > To: Michael Davey > > > Subject: Re: SQL question, getting error and not sure why > > > > > > > > > I thought it gave you the highest record value, IE recrods > > > containing values > > > 1-10, it would return 10 > > > > > > > > > ----- Original Message ----- > > > From: "Michael Davey" <[EMAIL PROTECTED]> > > > Newsgroups: php.general > > > To: <[EMAIL PROTECTED]> > > > Sent: Thursday, May 30, 2002 10:52 AM > > > Subject: Re: SQL question, getting error and not sure why > > > > > > > > > > > insert into acteursenc (nuacteur,nomacteur) > > > > > (select AA, BB from > > > > > (select max(nuacteur)+1 AA from acteursenc), > > > > > (select 'Michael Sweeney' BB from acteursenc))" > > > > > > > > > > produces an ORA-00001: unique constraint error. > > > > > > > > > > The primary key is nuacteur, but by setting AA to max(nuacteur)+1 I > > > should > > > > > be getting a new key that is unique, however it does not seem > > > that way. > > > > > > > > > > What am I doing wrong here? > > > > > > > > I'm not an Oracle expert, but surely max(field) + 1 is one > > > higher than the > > > > maximum value possible for the column? > > > > > > > > (Probably irrelevant snippet from mySQL manual: > > > > MAX(expr) > > > > Returns the minimum or maximum value of expr. MIN() and MAX() may take > a > > > > string argument; in such cases they return the minimum or maximum > string > > > > value.) > > > > > > > > regards, > > > > > > > > Mikey > > > > > > > > > > > > > > > > > > > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php