Subject | YAB ? (Yet Another Bug) |
---|---|
Author | Paul Poulain |
Post date | 2001-10-11T09:13:58Z |
Hi,
I've a DB with firebird (recent build). The admin front end is QuickDesk
1.7.10.14.
The table COMMAND has a after-insert trigger that insert a line into a
MOVEMENT table for the accounting process.
This trigger calls a stored proc.
It works fine.
Yesterday, I added a column in the MOVEMENT table and modified the strored
proc accordingly. The column is a copy of a COMMANDE-column.
Surprised : the column is always NULL.
Made a mistake ? No, the code seems OK. So, I try to call the stored proc
'by hand' : Works fine...
Mhhhhh... strange very strange.
Maybe a /init.rc/firebird restart ???
Oh yeah, it works perfectly fine now.
Can someone give me an explanation ?
Paul
I've a DB with firebird (recent build). The admin front end is QuickDesk
1.7.10.14.
The table COMMAND has a after-insert trigger that insert a line into a
MOVEMENT table for the accounting process.
This trigger calls a stored proc.
It works fine.
Yesterday, I added a column in the MOVEMENT table and modified the strored
proc accordingly. The column is a copy of a COMMANDE-column.
Surprised : the column is always NULL.
Made a mistake ? No, the code seems OK. So, I try to call the stored proc
'by hand' : Works fine...
Mhhhhh... strange very strange.
Maybe a /init.rc/firebird restart ???
Oh yeah, it works perfectly fine now.
Can someone give me an explanation ?
Paul