c# inserting boolean into access yes/no field

grahamor · 17-01-2008 05:09PM #1

Hi,

im trying to insert the value of a checkbox (true,false) into an access db.

The datatype for the column is Yes/No type.

when i try to insert this i get : Data type mismatch in criteria expression

im am setting the variable like

bool filled = chkFilled.Checked;

and the sql is normal stuff but it's not working.

Any ideas ?

Thanks

Evil Phil · 17-01-2008 07:20PM

Post the sql code, I'd make an educated guess as to that being the cause of the error.

grahamor · 18-01-2008 08:52AM

Here is what i have so far, if i remove the filled and active lines from the sql it works.

        bool filled = chkFilled.Checked;
        bool active = chkActive.Checked;
        

        string sql = "UPDATE jobs SET ";
        sql += "[type]='" + type + "',";
        sql += "[ref]='" + reference + "',";
        sql += "[title]='" + title + "',";
        sql += "[desc]='" + description + "',";
        sql += "[location]='" + location + "',";
        sql += "[salary]='" + salary + "',";
        sql += "[posted]='" + date + "',";
        sql += "[filled]='" + filled + "',";
        sql += "[active]='" + active + "'";
        sql += " WHERE id=" + id + "";

        connect.connectDb(sql);

Thanks

nialo · 18-01-2008 11:02AM

Your passing your boolean values as strings. This is what is causing the problem i think.

sql += "[filled]=" + filled + ",";
sql += "[active]=" + active + "";

stevenmu · 18-01-2008 11:07AM

I think you're problem is with the apostrophes, they denote that you're trying to put a string value into the field, so it's trying to update those fields with either the word "true" or the word "false" as opposed to the the yes/no value. Try it with the lines
sql += "[filled]=" + filled + ",";
sql += "[active]='" + active + "";

grahamor · 18-01-2008 12:11PM

Thanks guys, that solved it.

c# inserting boolean into access yes/no field

Comments