| Subject | Re: [firebird-support] Strange errors while creating a trigger |
|---|---|
| Author | Helen Borrie |
| Post date | 2005-02-25T13:03:16Z |
At 01:58 PM 25/02/2005 +0200, you wrote:
maxLogID = (select gen_id("LogTable_GEN", 0)
from RDB$DATABASE);
is not valid PSQL. It would have to be
select gen_id("LogTable_GEN", 0) from RDB$DATABASE
into :MaxLogID;
But, as others pointed out, calling GEN_ID() directly is cheaper.
./helen
>Hi IvanAlso
>
>Thanks for your quick reply. Also thanks to Martijn. The maxLogID variable
>issue is fixed - as you mentioned, the "select" statement was too much.
maxLogID = (select gen_id("LogTable_GEN", 0)
from RDB$DATABASE);
is not valid PSQL. It would have to be
select gen_id("LogTable_GEN", 0) from RDB$DATABASE
into :MaxLogID;
But, as others pointed out, calling GEN_ID() directly is cheaper.
./helen