SQL update statment, using ACCESS yes/no

  • Thread starter Thread starter Bonzol
  • Start date Start date
B

Bonzol

VB.net 2003, 1.1, webapplication
hey there connecting to an Access database.
There is a field in the database that is yes/no
What do I pass in to the datbase to make it check the box, or uncheck
it? I have tried "yes", "no", "true", "false", but i cant get it right

e.g
SQL = UPDATE Users SET Name = TRUE WHERE ID = 1

anyone got a clue?
 
Hello, Bonzol,

I also would have expected that SQL to work. Perhaps the problem is
somewhere else. Can you try running the query from directly within
Access? That might provide a clue as to whether the problem is with the
query or the web-app.

Cheers,
Randy
 
Back
Top