Subject | INSERT ... RETURNING bug in embeded? |
---|---|
Author | ainpoissee |
Post date | 2008-03-12T14:17:30Z |
Hi,
I'm using fbembed.dll 2.0.3.12981 and when using insert statement like
INSERT INTO TAB_Txt(UID,Name,Category,Txt)
VALUES(GEN_ID(GEN_TAB_Txt,1), :Name, :Category, :DocData) RETURNING UID
the value returned for UID is 0. When I move that same database to
remote server, same statement works OK (non-zero UID value is returned).
Similar insert statements work with another table OK (also in
embeded), the difference between the tables is that the other one
doesn't have BLOB field in it (in TAB_Txt field Txt is of type BLOB
SUB_TYPE 0).
Can't see what I'm doing wrong... so is it some known problem or
should I look for a bug in my own code?
TIA
ain
I'm using fbembed.dll 2.0.3.12981 and when using insert statement like
INSERT INTO TAB_Txt(UID,Name,Category,Txt)
VALUES(GEN_ID(GEN_TAB_Txt,1), :Name, :Category, :DocData) RETURNING UID
the value returned for UID is 0. When I move that same database to
remote server, same statement works OK (non-zero UID value is returned).
Similar insert statements work with another table OK (also in
embeded), the difference between the tables is that the other one
doesn't have BLOB field in it (in TAB_Txt field Txt is of type BLOB
SUB_TYPE 0).
Can't see what I'm doing wrong... so is it some known problem or
should I look for a bug in my own code?
TIA
ain