03-02-2023 05:31 AM
when i fetch data from data base the values for coloumn true will fetch -1 and 0 for false i need exact data from the sql . Can u Please help me to sort this things out .
03-02-2023 06:27 AM
Here a previous post about the same subject :
https://forums.ni.com/t5/LabVIEW/sql-server-bit-data-type-value-1-returns-1/td-p/1799726
03-02-2023 09:43 AM
That is correct. A Boolean is defined as F=0 and T<>0. -1 <>0, thus True.
You just need to use the primitive 'Not equal to 0'