how to change true into false in access table from c#

Question

Hi simple question simple! How to change true into false or false into true in access table. I try to update record with false into true. How ??? 1 try => parametarSQL = UPDATE Vrsteprojekata SET dostupan = ' + false + ' WHERE id = ' + id + '; -> nothing.... 2. try => parametarSQL = UPDATE Vrsteprojekata SET dostupan = false WHERE id = ' + id + '; -> nothing.... 3. try => parametarSQL = UPDATE Vrsteprojekata SET dostupan = 0 WHERE id = ' + id + '; -> nothing....

Vulpes · Answer

Well to update a yes/no column in MS Access I'd have expected #2 and #3 to work but not #1 because you're putting single quotes around False. So if they're not working then perhaps the problem lies elsewhere. Is your 'id' column an Integer or a Text column? If it's the former then try removing the single quotes around it.

GoGi Febo · Answer

Oh sorry problem solved. Option 2. work I had syntax error in variable name...