LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

SQL bit formate convert

In SQL, there is a bit data format which stands for true or false. I fetch this data from SQL server. however, after "Variant to Data". it is display as -1 or 0. how can I force them show "true" or "false".

Untitled.png

Untitled.png

0 Kudos
Message 1 of 3
(3,117 Views)

Hi song,

 

use comparison function "<0". Or better compare with <> "0" as you read strings…

 

It would really help to crop your images before uploading them!

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 2 of 3
(3,114 Views)


What image you posted is the image of SQL or your table? Also why dont you use database to varient?

 

Also ensure whenever you post any image we dont have to use microscop to see

--------------------------------------------------------------------------------------------------------
Kudos are always welcome if you got solution to some extent.

I need my difficulties because they are necessary to enjoy my success.
--Ranjeet
0 Kudos
Message 3 of 3
(3,087 Views)