Loading

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

GoGi Febo

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....

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

GoGi Febo12y ago
Oh, sorry, problem solved. Option 2. work, I had syntax error in variable name...
0
Vulpes12y ago
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.

+1