Trying to change the primary key to autovalue in an existing database. I see the suggested solution here, but when I try to follow it I get asked “The column ‘ID’ could not be changed. Should the column instead be deleted and the new format appended?” and then, after saying yes, the following error:
ID autoincrement
firebird_sdbc error:
*unsuccessful metadata update
*ALTER TABLE Table1 failed
*SQL error code = -607
*Invalid command
*Specified domain or source column SQL_LONG does not exist
caused by
‘ALTER TABLE “Table1” ADD “ID” SQL_LONG NOT NULL’
Alternately, trying to just delete the field and add a new one results in this error:
firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Token unknown - line 1, column 48
*GENERATED
caused by
‘isc_dsql_prepare’
If there’s no way to change the field, is there a way to extract all the data from the other fields and import it into a new database, or some other option?
I’m running LibreOffice 7.0.0.3 on Windows 10.