Hi all, Lazarus developers !
I try this example on FPC 2.4.4 and Lazarus SVN latest with SQLDB, Firebird 2.5, Ubuntu 11.04.
with DBQuery do begin
Close;
SQL.Clear;
SQL.Add( 'INSERT INTO katalog (id, name) VALUES (NULL, :name) RETURNING id');
Params[0].AsString := 'BlaBlaBla'; // ParamByName('name').AsString := 'BlaBlaBla';
Open;
Result := Fields[0].AsInteger; // FieldByName('id').AsInteger;
Close;
end;
After Open I got an error : -Dynamic SQL error, - SQL error code = -504, - Invalid cursor reference, - Cursor is not open.
I also try it with latest FPC SVN 2.7.1, Lazarus latest SVN, with same result !
I'm wondering it is broken functionality on SQLDB or I miss something ?
With ZeosDBO 7.0 latest SVN the result is perfectly what is expected !!!!
(sorry for my English !)
Best regards : Patyi