Bit Column In A Query Where Clause

  • Thread starter Thread starter g11DB
  • Start date Start date
G

g11DB

The Query inside my MS Access database looks like the following:


Code:
SELECT
dbo_MyTab1.MyCol4, dbo_MyTab2.MyCol3
FROM
dbo_MyTab2 INNER JOIN dbo_MyTab1
ON dbo_MyTab2.MyCol2 = dbo_MyTab1.MyCol2
WHERE
(((dbo_MyTab1.MyCol1)=0)
AND dbo_MyTab1.MyCol3 NOT LIKE '%Expr%')
AND ((dbo_MyTab2.MyCol4)=False)));

Given that in the backend database (sql server 2005):

Code:
MyTab1.MyCol1 is (bit, not null)
MyTab2.MyCol4 is (Flag(bit), not null)
The problem is that when I execute the query, it prompts a dialog box asking for the value of MyTab1.MyCol1.
There should be none of this dialog pop-up. Anyone encountered this before?

Hope this helps make the problem clearer?
 
hi,
SELECT
dbo_MyTab1.MyCol4, dbo_MyTab2.MyCol3
FROM
dbo_MyTab2 INNER JOIN dbo_MyTab1
ON dbo_MyTab2.MyCol2 = dbo_MyTab1.MyCol2
WHERE
(((dbo_MyTab1.MyCol1)=0)
AND dbo_MyTab1.MyCol3 NOT LIKE '%Expr%')
AND ((dbo_MyTab2.MyCol4)=False)));
The problem is that when I execute the query, it prompts a dialog box asking for the value of MyTab1.MyCol1.
There should be none of this dialog pop-up. Anyone encountered this before?
Click to expand...
Sounds like a naming problem, as you see you linked tables are prefixed
with "dbo_", where the pop-up requests a value for "MyTab1.MyCol1"
without that prefix.


mfG
--> stefan <--
 
hi,
Code:
AND ((dbo_MyTab2.MyCol4)=False)));

Given that in the backend database (sql server 2005):
Code:
MyTab1.MyCol1 is (bit, not null)
MyTab2.MyCol4 is (Flag(bit), not null)
Click to expand...
There may also arise some problem with representation of BIT columns,
you should change your comparison to

dbo_MyTab2.MyCol4 = 0

for False and

dbo_MyTab2.MyCol4 = 1

for True.


mfG
--> stefan <--
 
Back
Top