[Libreoffice-bugs] [Bug 112491] SDBC-mismatch on alter field-properties in embedded Firebird database when editing primary key

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112491

--- Comment #16 from justforthis7 at outlook.com ---
I am having this issue too. Am finding creating/editing tables in Firebird/LO
base a nightmare. (About to report another bug) 
I am finding that what is displayed in the edit table GUI often does not
reflect the actual situation. If you edit a table and the change doesn't seem
to have been made, close the table (saving or at least trying to save. if you
get an error message close without saving if nec) and reopen. Often your change
will have been made. If it hasn't try exiting LO and reopening. 
'After a table has been saved, I am unable to change the primary key AutoValue
from No to Yes. When I try to save a table after making this change, I get an
error message: "Warning The column "Field Name" could not be changed. Should
the column instead be deleted and the new format appended?"' 
My main work round is create new tables from calc or from copying without a
primary key and then edit the table and add one. (It will be at the end of the
table, so if required use SQL to move the field to desired position, you won't
see the field has moved until you have closed and reopened the table editor) )
Otherwise change the field to autovalue, try to save, you'll get an error
message. Ignore it, close without further saving. Open it and the problem field
will have been deleted and you can enter a new one.
Just updated and still have same problem 
Version: 7.0.0.3 (x64)
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200819/7854ae58/attachment-0001.htm>