--- In firebird-support@yahoogroups.com, "ainpoissee" <ainpoissee@...>
wrote:

>
> 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).

I now also tested with 2.1 RC2 embeded with the same result -
inserting into table which doesn't have BLOB field works OK while
inserting into table with BLOB returns 0 for UID. It looks like it
doesn't make difference do I actually include that BLOB field into
INSERT statement or not.
I'm using UIB components (TJvUIBQuery) to execute SQL statements...
any idea?


TIA
ain