x+1? What does that do?

To get the same as Oracle, simply create a
generator (pretty much the same as a Sequence
in Oracle) and use:

select gen_id(yourgenerator, 1) as nextval
from rdb$database


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com

> select x +1 from RDB$DATABASE,
> or use generator
> define generator maygen ;
> and bind it to a trigger " before insert "
> Source for the trigger:
> as
> declare variable actionid integer;
> declare variable dessnr char(6);
> declare variable bildstatus char(1);
> begin
> /* Trigger text */
> dessnr = old.dess_nr;
> -----> actionid = gen_id(gen_action_id_dessin,1);
> <---------------------------------
> ) ;
>
>
> look at the documentations under www.ibphoenix.com
>
>
> Zhibin Sun wrote:
>
> >Hi ib-support: what's sql statement in interbase for "select

MySequence.nextval from dual" in Oracle? best regards. S.Wolf

> >