Zeoslib Portal

Seawolf, yes, with fb 2.0, that worked fine... it has the minor inconvenient of "Open()" do not trigger the autocommit but it makes sense, after all its just an "open" :P Mark, thats the problem... maybe its because FB 2.5 is beta and thats just a bug, not a feature... but I can'...

A little more information on this... I tried the same case with dbExpress and IBDAC from DevArt... with dbExpress I can get the "returning" value using Active := true; Fields[0].Asinteger; <- here is my returning field BUT, as occurred with ZEOS, that do not work on FB2.5, only on 2.0. One...

(sorry for my bad english) I have on machine with windows XP and Firebird 2.0 and one with windows vista and firebird 2.5 beta 2 - both with ZEOS 6.6.5-stable. I compiled a simple example similiar to: zquery.sql.add('INSERT INTO TPRODUTO (NMPRODUTO) VALUES ('TESTE') RETURNING ID'); zquery.Open(); Sh...

Firebird 2.X supports a query like: INSERT INTO TABLE (FIELD2, FIELD3) VALUES (1,2) RETURNING FIELD0; Thats a nice way to return an auto-generated field. How can i get that value using ZEOS? If I do a ExecSQL, it doesn't return any field. If I try with Open() it give me the error "Invalid curso...