Hello! This is my first attempt at creating a database in LibreOffice. I started a brand new database and attempted to create the first table with the Table Wizard. When I clicked “Finish” I got the following error (see picture). How do I fix this as I didn’t actually write any code, just entered values into the wizard?
Am using LO v 24.2.7.2 on Linux Mint 21
how did you select for example FoodID ?
can’t see it from TableWizard.xcu (revision 3466475d) - OpenGrok cross reference for /core/officecfg/registry/data/org/openoffice/Office/TableWizard.xcu
The problem is FLOAT(17,. May be, that silly wizard tries to declare something like DECIMAL(17,2) (17 digits, 2 after the point), but with FLOAT instead of decimal. FLOAT takes only one argument.
The easiest way to create a working database is a pen and paper draft followed by plain, simple SQL.
… and if you don’t know anything about SQL: Use Create Table in Design view…. I’m only using this way, not SQL directly. And I never used the wizard.
Thank you! This was it.
The values were originally Decimal, which had a “5” in the “Decimal places” box. When I selected “Float”, the 5 stayed and the -/+ were greyed out so I couldn’t change it. I had to change the field type to something else, then back to Float and the “Decimal places” reset to 0.
Unfortunately, when I tried to finish the wizard this time it crashed and I lost the whole table (frustrating as it had many, many columns). I will take RobertG’s advice and use the Design view this time.
