Sql database user lacks privilege or object not found <Solved>

LSemmens · September 23, 2019, 1:35am

I have been developing a database to catalogue my stamp collection. It is a split database and has been normalised as best I can. I am now attempting to perform an update on one field in one table for about 4000 records but the SQL command

update MASTER set SM_TYPEID = “28” where SM_TYPEID = "0"

responds with the: 1: user lacks privilege or object not found: 0

The table name and the field names are correct and capitalised correctly. What am I missing? I am very new to SQL and LibreOffice Base, but am familiar with Databases generally,.

LSemmens · September 23, 2019, 1:44am

Thank You now Solved!

Ratslinger · September 23, 2019, 1:49am

@LSemmens,

Please note, there is no need to mark the title solved. That is understood when check mark is clicked on.

Ratslinger · September 23, 2019, 1:40am

Hello,

Quotes signify (in most cases) a table or field name. Surround 28 & 0 with apostrophe instead (single quote if you prefer).

Ratslinger · September 23, 2019, 1:46am

Note, depending upon data type and usage no quoting at all will most likely work.