Subject Generator Fires Twice??
Author delphigurusam
Sorry if this is a report.
I thot I had posted this question last Thurs, but my msgs have been
getting bounced and I couldn't find it in the threads.

The following statement used to work.
(pg 648 Helen's book)

sql.add('SELECT GEN_ID(GEN_PK_CONSTITUENTS,1) AS RESULT FROM
RDB$DATABASE');

and did exactly what it was supposed to do - grab the new record ID
created by the GEN_PK_CONSTITUENTS generator when the BI trigger
fired.

Now, I get the following error when I attempt to trace (in Delphi)
thru this line of code:
"SQL error code = -104
Unexpected end of command'.

Also, the trigger value is destroyed and the above statement causes a
new value to be created.

Any ideas?
Thx
Sam Hunt