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
>
>
>---------------------------------
>Do You Yahoo!?
>"雅虎通网络KTV, 随时随地免费卡拉OK~~"
>
>[Non-text portions of this message have been removed]
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>.
>