SQLIte and CheckBox (boolean Value)
lazarus / 16-Databases

----------------------------------------------------------------------
folkeu08 · 2020-12-16 14:07

Hello,
I am using an SQLite database and I want to save a boolean value in a
field of a table.
I am using a CheckBox (not a DBCheckBox) for that.
Using this command:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
Cell_DataModule.Cell_SQLQuery.Params.ParamByName ('Present').
AsBoolean: = Present_CheckBox.Checked; For False the value is -1 and
True the value is 1.
How to get 0 for an unchecked Chekbox.
Thanks

----------------------------------------------------------------------
dseligo · 2020-12-16 14:11

Try:

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
Cell_DataModule.Cell_SQLQuery.Params.ParamByName ('Present').
AsInteger: = Ord(Present_CheckBox.Checked);