SQLite update field with count from another table

Question

Hello,

I am trying prepare a table before exporting to CSV however the Sqlite administrator software I am using is reporting invalid syntax. Anybody see whats gone wrong?

UPDATE 'tblTags'
SET 'tagUsageCount' =
(SELECT COUNT(*) FROM 'tblTagLinks'
WHERE 'tblTagLinks'.'TLTagId' = 'tblTags'.'tagId')

Answer 1

SQLiteSpy doesn't report a syntax error.
Can you try to un-stringify the names? ie 'tblTags' --> tblTags

Answer 2

There is no semicolon ; at the end. Otherwise the syntax is valid.