Forum > Databases
[SOLVED] SQLite delete a record with no visible ID
rvk:
--- Quote from: Pe3s on September 25, 2022, 06:06:46 pm ---there is an id in the project, but I don't want to see it in the table
--- End quote ---
I already said you could hide it in the tdbgrid.
But it should be in the sql.
Pe3s:
Thank you :)
Zvoni:
And since it's SQLite it doesn't even matter if you have an explicit Primarykey (though i do agree that leaving out an explicit PK is a big design-fault).
As long as your table is not created with the option "WITHOUT ROWID" you'll always have a "hidden" primary Key
https://sqlite.org/rowidtable.html
Navigation
[0] Message Index
[*] Previous page