Can't write boolean to table

[696796]

I am setting a public boolean variable inside my code. I am then writing to my table using the following sql...

strSQl = "INSERT INTO tblTest (testDate, serialNumber, countryId, volume1, volume2, volume3, averageVolume, range, volumeAdjust, finalVolume, pass)"
        & "VALUES('" & dtDate & "' , '" & strSerial & "', '" & intCountry & "' , '" & dblVolume1 & "', '" & dblVolume2 & "', '" & dblVolume3 & "', '" & intAverage & "', '" & dblRange & "', '" & dblVolumeAdjust & "', '" & dblFinalVolume & "', '" & blnPassFail & "')"
[\code]

My pass column is datatype Yes/NO, with the format set to True/False - in the table it looks like a check box.

Now i thought by setting the variable blnPassFail to true, it should add that in using this sql, i have broken the code and all the values are there, it just doesn't tick the pass box in my table if blnPassFail is True.

Can anybody see the error in my ways??

Many thanks, 

Alex

 

[696796]

Sorry, this is the sql statement...

strSQl = "INSERT INTO tblTest (testDate, serialNumber, countryId, volume1, volume2, volume3, averageVolume, range, volumeAdjust, finalVolume, pass)" _
        & "VALUES('" & dtDate & "' , '" & strSerial & "', '" & intCountry & "' , '" & dblVolume1 & "', '" & dblVolume2 & "', '" & dblVolume3 & "', '" & intAverage & "', '" & dblRange & "', '" & dblVolumeAdjust & "', '" & dblFinalVolume & "', '" & blnPassFail & "')"

 

[PHV]

Replace this:
& "', '" & blnPassFail & "')"
By this:
& "', " & blnPassFail & ")"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[696796]

thankyou