I’m using LO 6.1.5 (latest stable) and have data in a CALC spreadsheet that I have successfully imported (allowing the LO Base interface to add a autoincrement primary key).
At this stage (after the successful import process), all the columns (except for the PK) are showing as TEXT datatype of 255 characters in length - including a DATE column and two other numeric (currency) columns (which should be formatted at DECIMAL(7,2).
I have set all the columns in the original IMPORTED Calc sheet with the correct TEXT, DATE and CURRENCY formating. However, these above settings do NOT seem to have been respected in the COLUMN datatype settings as used by FIREBIRD. (i.e. They all show up as TEXT/VARACHAR columns of 255 length - as mentioned above).
To fix things, I have tried to change the datatype (and text-field length) of specific columns by running SQL code in the SQL window, such as:
ALTER TABLE “bank_list” ALTER COLUMN “date” DATE;
However, I always get an error message:
1: firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Token unknown - line 1, column 48
So what am I doing wrong? Any help would be much appreciated. With thanks.