Thank you very much to all
> select gen_id(GEN_AGENDA_NRO, 287390 - gen_id(GEN_AGENDA_NRO , 0)) from
> rdb$database
An ugly hack, I agree, but works.
>This does make you wonder if maybe RESTART WITH shouldn't fall under
>USAGE instead of the ALTER privilege (or alternatively if using gen_id
>with anything other than
On 5-10-2018 18:42, m_brahi...@yahoo.fr [firebird-support] wrote:
> I need to know please, what is the limit of record in a table with more
> than a hundred fields in FB 3 without reaching the 64 KB maximum row
> size. How many records my table must contains ?
Hi, from http://www.ibphoenix.com/resources/documents/general/doc_323
Maximum row size for user tables - 64KB.Count bytes. BLOB and ARRAY
columns each cost 8 bytes to store the ID; VARCHARs, byte length +
2;CHARs, byte-length; SMALLINT, 2; INTEGER, FLOAT, DATE and TIME, 4;
BIGINT, DOUBLE
Hello,
I need to know please, what is the limit of record in a table with more than a
hundred fields in FB 3 without reaching the 64 KB maximum row size. How many
records my table must contains ?
Sorry if my question seems lazy.
Thanks
On 5-10-2018 15:13, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
> Hello,
>
> I'm migrating from Firebird 2 to Firebird 3
>
> When setting a generator, I get the following error:
>
> SET GENERATOR GEN_AGENDA_NRO to 287390;
>
> unsuccessful metadata update
> SET
Hello,
I'm migrating from Firebird 2 to Firebird 3
When setting a generator, I get the following error:
SET GENERATOR GEN_AGENDA_NRO to 287390;
unsuccessful metadata update
SET GENERATOR GEN_AGENDA_NRO failed
no permission for ALTER access to GENERATOR GEN_AGENDA_NRO
The same
It's not homework assignment. I always try to play with SQL and just got an
idea to deal with such tasks, as there are always new requirements come for
displaying report with different formats.
Mostly I try to get the output from SQL execution part itself rather than
stored procedure or from