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
