ddepuemd
asked on
insert into yes/no field of ms access in vb.net
Do you use 'true' and 'false' or 'checked' and 'unchecked' or 1 and 0??
you can use True and False but better to use 0 and 1 (-1)
Gary
Gary
ASKER
Both methods gives me a syntax error. do I put single quotes around?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do you have two fields ? you're trying to insert two fields!
You also should change the connection string indicating the fields and the values to insert. If you have an autonumber field you don't use it in the connection string because it's automatically filled
Dim sql As String = "insert into actions(field1, field2, field3) VALUES (value1,value2,value3)"
You also should change the connection string indicating the fields and the values to insert. If you have an autonumber field you don't use it in the connection string because it's automatically filled
Dim sql As String = "insert into actions(field1, field2, field3) VALUES (value1,value2,value3)"
ASKER
Dim sql As String = "insert into actions ('main','PART INSPECTION',true,false)"