Ask Your Question
0

Firebird Base: SQL CREATE TABLE Statement

asked 2020-10-17 03:24:32 +0100

lonk gravatar image

updated 2020-10-17 06:33:40 +0100

Fedora 32 Cinnamon Desktop of Fedora from Spins

LibreOffice 7.0.2.2-2

Why do .odb file has to be closed and query has to be run over three times in order to create a table, namely Table_1 ?

C:\fakepath\FirebirdTest_CreateTableFromQuerySQL.odb

image description

Running query each time, is this message normal ?

image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2020-10-17 05:00:39 +0100

frofa gravatar image

updated 2020-10-17 06:30:35 +0100

On LO 6.4.6.2 (on Mac OS), I also get problems similar to yours and others have had.

I get a somewhat different error message after running (from the normal Queries window) your own query code to create the new table. See below:

image description

.... but I ignore (close) it.

IMPORTANT NOTES

  1. The new table does NOT show up in the table listing until I do a REFRESH TABLES (under the VIEW menu and only enabled in the Tables window). You must also close a BLANK window that opens up at that point (at least on my setup)
  2. IMPORTANT: If you close the database without doing the REFRESH step above, and then re-open it, there will be no table saved! (And also NO warning to SAVE the Base file before closure!)
  3. Base does NOT update the Firebird database automatically like it does with HSQLDB (at least for table creation). It seems to require a a REFRESH to do that. Also see the above-mentioned POST and the answer given by Ratslinger

Do post back if you want to add anything to the above, and TICK this post if it answers your question.

edit flag offensive delete link more

Comments

Dear @frofa,

Thank you so much for your answer.

It really came after Refresh Tables.

lonk gravatar imagelonk ( 2020-10-17 06:37:45 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-10-17 03:24:32 +0100

Seen: 80 times

Last updated: Oct 17 '20