This blogpost coming soon, meanwhile you can still download the assets via the yellow email box below.
Install Firebird Server For LibreOffice Base
This blogpost coming soon, meanwhile you can still download the assets via the yellow email box below.
I’m new to Firebird and could not believe that one needs to create a sequence and a trigger in order to get a simple auto-ID. When I tried, I could not enter new records in the LibreOffice UI whereas INSERT statements worked as expected, incrementing the new ID numbers.
Turns out that Firebird3 supports GENERATED BY DEFAULT AS IDENTITY (START WITH 10000).
The auto-ID created this way shows in the new record and behaves properly in the LibreOffice UI.
Instead of macros, I published a Writer template which can be used to generate the SQL statements for a database with 5 tables with relations. https://forum.openoffice.org/en/forum/viewtopic.php?t=110117 [Using Writer to generate a database skeleton].
Thanks Andreas.
I’ve tested what you said and it works, the Firebird documentation is huge, I guess I got confused because you’ve got to use the trigger and generator combo for Firebird 2.5 and earlier.
On another note, you mentioned that you were unable to add records in the LibreOffice UI unless you used an insert statement.
I had that problem on a couple of tables, it turned out that the cause was that a Primary key had not been defined, once the primary key was defined the add record row returned.
Hello Sean,
When time allows – continuation of your LibreOffice Base Firebird Server series would be appreciated. Thanks.
/r Ted Baker,Newry, Maine, US
Thanks Ted, I’ve learned a lot since that video, I need to just come up with some kind of case study to make a video about.