From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

Home Community Discussion Forums Most Active Software Boards LabVIEW Topic

LabVIEW

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SQL bit formate convert

SQL bit formate convert

‎10-14-2014 02:39 AM

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
(2,815 Views)
Reply

Re: SQL bit formate convert

‎10-14-2014 03:01 AM - edited ‎10-14-2014 03:02 AM

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
(2,812 Views)
Reply

Re: SQL bit formate convert

‎10-14-2014 07:22 AM


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
(2,785 Views)
Reply