Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have a SQL database that contains a logical field. When I import that field into QV, it displays as either "-1" or "0". However, when I viewed it in the native SQL format, it was "1" or "0". Does QV convert SQL's default logical values to its own values (i.e. the number displayed, not true or false) when it imports the table?
Hi
As per my test, i can see 1 and 0 for true n false in qv. for bit values..
ODBC CONNECT TO TestPurpose;
LOAD logic,
mark;
SQL SELECT logic,
mark
FROM Northwind.dbo.TEST;
Sql:
create table test(logic bit, mark int);
insert into test values('true',42);
insert into test values('true',4);
insert into test values('true',34);
insert into test values('true',24);
insert into test values('false',2234);
Select * from test;
Test table o/p:
logic | mark |
1 | 42 |
1 | 4 |
1 | 34 |
1 | 24 |
0 | 2234 |
Please see the attached file for qv .
Hope it helps