[Libreoffice-bugs] [Bug 128558] Firebird Embedded : Auto-numbering can be overwritten

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128558

--- Comment #7 from Richard Palusaar <bugzilla at sublogic.se> ---
If needed, an auto value counter can be reset to continue from any arbitrary
value of your choosing. This is done using an SQL statement.

SET GENERATOR GeneratorName TO NewValue;

Reference: Firebird Generator Guide: A guide on how and when to use generators
in Firebird - 3.2.4. Setting a generator directly to a certain value (“Update”)

URL:
https://www.firebirdsql.org/file/documentation/html/en/firebirddocs/generatorguide/firebird-generator-guide.html#generatorguide-sqlsyntax-setvalue

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200728/4ecfc2e6/attachment.htm>