1) If
PID
is numeric field, remove
'
.
DC.CmdStatement("update Valid set Pcheck=1 where PID=" + textBox1.Text);
2) In MS Access
YES/NO
|
TRUE/FALSE
field, every
YES/TRUE
value is
-1
and every
NO/FALSE
is
0
(zero).
You can check it, using simple trick:
SELECT CInt(YES) AS YesValue, CInt(NO) AS NoValue, CInt(TRUE) AS TrueValue, CInt(FALSE) AS FalseValue;