cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

SQL bit formate convert

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
(488 Views)

Re: SQL bit formate convert

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
CLAD, using 2009SP1 + LV2011SP1 + LV2017 on Win7+cRIO
Kudos are welcome Smiley Wink

0 Kudos
Message 2 of 3
(485 Views)

Re: SQL bit formate convert


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
(458 Views)