Hello, I’m a newbie with LO Base, trying to move from MS Access. I’m no expert in Access, but I do have considerable experience with enterprise DBMS (mostly Oracle), mainly on the design/modeling side, not so much as DBA.
In Base, I’ve created a table using Firebird (embedded) SQL (Tools > SQL…) The table doesn’t show up in the Tables list. In order to show the table, I must exit LO Base and come back in, then it’s visible in the Tables list.
Am I doing something wrong? Is there any way to get tables created with Firebird SQL to show right after creation?
If you’re wondering, I’m using SQL, rather than the LO Base Design View or wizard because I’m creating default timestamp columns (RecordCreateTMS and RecordUpdateTMS [still working on the latter]) and I want to create this in one CREATE statement instead of creating the table and then ALTERing the column(s).
One additional question: if I’ll be creating triggers and other database objects, is it better to use a standalone installation of Firebird and just connecting to it, rather than going through LO Base front end with the embedded Firebird?