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

>
> --- 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?

I don't have 2.x installed right now, but have you tried the query in
iSQL?

If it works -> UIB bug / limitation
If not -> Firebird bug (report in tracker)

Adam