yes, in that way the query i suggested would look like:
insert into acteursenc
(nomacteur)
values
('Michael Sweeney')
and nuacteur would be provided by the before insert
trigger automatically. that's like mysqls autoincrement.
Michael
"Rouvas Stathis" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I would use a trigger with a sequence, as in:
>
> CREATE SEQUENCE <sequence_name>_SEQ
> INCREMENT BY 1
> START WITH -99999999999999999999999999
> MAXVALUE 9999999999999999999999999999999999999999999999
> MINVALUE -999999999999999999999999999999999999999999999
> CYCLE CACHE 5 ORDER;
>
> create or replace trigger <trigger_name>_autonum_ins
> before insert on <table_name>
> for each row
> begin
> if :new.<field1> is null then
> select <sequence_name>_seq.nextval into :new.<field1> from dual;
> end if;
> end;
>
> -Stathis.
>
> Michael Sweeney wrote:
> >
> > 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)
> >
>
> --
> Rouvas Stathis
> [EMAIL PROTECTED]
> http://www.di.uoa.gr/~rouvas
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
