TSQLQuery Filter not work on boolean value
lazarus / 16-Databases

----------------------------------------------------------------------
babycode · 2024-05-10 16:23

Greetings

I'm trying to use a filter in TSQLQuery.Filter that works perfectly
when I put:
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 profile_id
= 1 and branch_id = 1
But when I try to use a Boolean field it doesn't work.

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 profile_id
= 1 and branch_id = 1 and active = False
"Index based on unknown field "False""

----------------------------------------------------------------------
babycode · 2024-05-10 16:34

I tried using the syntax:

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 profile_id
= 1 and branch_id = 1 and active
or 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 "and not
active"
And it worked.