Trying to make a new table in table design view. When I went to save the table, I received the error below. I’ve tried to research this, but couldn’t find anything helpful. Any help is appreciated.
Maybe you are using a length not allowed VARCHAR(32765).
I think it has something to do with the field length. When I first built the table, I changed a couple fields to make them smaller and got errors. When I rebuilt it, I left everything at the default length and it worked out alright.
Thank you for your idea. It seemed to be something to do with field length. I eventually became frustrated and started from scratch – again. This time, I built the table only a few fields at a time, to try to isolate the problem.
It only occurred when I both inserted a new field AND tried to change the field character size from the default. The weird thing is that I was making the character size smaller, not larger, but still got that weird error. If I left the character size at the default, saved, then went back in to alter the size, I didn’t have any problems! (Does this indicate another bug?)
I have run into multiple problems since changing over to the Firebird engine that didn’t occur with the old HSQLDB engine. I’m beginning to regret updating LO. Part of the problem may be my inexperience, but this FIrebird engine is not ready for use – at least not by non-experts. It is not ready to be the default engine as of Sept 2019.