Subject | Generator Fires Twice?? |
---|---|
Author | delphigurusam |
Post date | 2005-08-09T18:17:25Z |
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
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