My following query : 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? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php