|Subject||RE: [firebird-support] Re: Complex generators?|
> ----Wow - Using DML on system tables and re-setting generator values from the
> IF (NEW.SIFRA IS NULL) THEN BEGIN
> genname = 'GEN_MASTER_' || new.type;
> update my$gen set val = val + 1 where name=:genname; /* locks
> record, if any */
> select val from my$gen where name=:genname into :num;
> if (num is null) then begin /* no such counter exists */
> insert into my$gen values(:genname, 1);
> num = 1;
> new.sifra = :num;
> That, and CachingUpdates works as I initialy thought - Thanks
> everyone, I learned much in the process :)
client - what a recipe for disaster in a multi-user environment! Good luck.
But believe me - you'll be back - you're going to have lots of problems now.