You can increase the Generator by its value, but be sure the first value of this generator is 1
select gen_id("GenAccID", gen_id("GenAccID", 0)) from rdb$database On Sat, Dec 6, 2008 at 5:00 PM, ik <ido...@gmail.com> wrote: > > Thanks for the answer. > > I wanted to do it using Firebird instead of my Pascal code.. now I > understand thanks to you, that I need to do it using stored procedure. > > Thanks, > Ido > > On Sat, Dec 6, 2008 at 4:38 PM, Francisco Reyes <li...@stringsutils.com> > wrote: >> >> ik writes: >> >> >>> I wish to create a firebird generator that does bitwise generation >>> rather then ordinal generator. >>> >>> I mean: >>> 1 2 4 8 16 32 64 128 etc.. >>> >>> Does anyone have knowledge how to create such generation in firebird ? >> >> I am not clear what you are trying to do. >> You are trying to generate the sequence above, that much I get. >> However, is it a pascal program which will be a firebird stored procedure? >> >> The algorithm to generate the sequence is trivial so I don't quite follow >> which part you are having problems with. The generation? The creation of the >> firebird stored procedure? >> >> If the question is how to generate the sequence in Firebird and not use >> FPC, then the answer is that you need to have some sort of stored procedure. >> You could even just have a table with the values. >> _______________________________________________ >> fpc-pascal maillist - fpc-pascal@lists.freepascal.org >> http://lists.freepascal.org/mailman/listinfo/fpc-pascal > > > _______________________________________________ > fpc-pascal maillist - fpc-pascal@lists.freepascal.org > http://lists.freepascal.org/mailman/listinfo/fpc-pascal > -- Zaher Dirkey _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal