I had a simple table, numeric autokey, text, longmemo. I decided i wanted the text field to be keyed and unique but couldn’t figure out how to make it disallow duplicates, so i made it the primary key and thought that it accepted that so i deleted the numeric key. I had not saved or something because when i closed, it threw errors. I no longer have a keyed field and i found the single duplicate that caused the failure, but i can’t delete it without a key. I tried creating a new key field but it doesn’t like that.
I’ve closed/opened and apparently it saved what i did; no keyed field.
What is the best way to fix this?
Version: 220.127.116.11 (x64)
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU threads: 8; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US