Hi,

At May 15, 2006, 6:30 AM, giannifilippone wrote:

> can anyone solve a doubt ?
> I'm using FB2+Zeos, all is OK & easy if I use TZsequence
> with normal autoinc.
> But I cannot re_set the generator number; my code here :

>>>>>>>
> conn1.starttransaction;
> SQL.Clear;
> SQL.Add('alter sequence sss restart with 7777');
> ExecSQL;
> conn1.commit;

> conn1.starttransaction;
> SQL.Clear;
> SQL.Add('INSERT into my_table ');
> SQL.Add('(cod, descr)');
> SQL.Add('values (:cod, :descr)');
> ParambyName('cod').AsInteger := sss.GetNextValue;
> ParambyName('descr').Asstring:= 'xxxx'+inttostr
> (sss.GetCurrentValue);
> ExecSQL;

> conn1.commit; >>>>> the new value 7777 is ignored and generator
> continues incrementing the old value !!?? <<<<<<<<<<<<<<<

Have you tried the same statements via the ISQL command-line tool?
That is just to eliminate ZEOS as the problem if the same thing
happens with ISQL. And, try with the new release candidate that just
came out.

Also, post your message in the Firebird-Devel group, since it relates
to a pre-release version of Firebird.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)