<div>
Hi ba272,<br />
----------<br />
<br />
if it works on some tables and not on others, then why not try to deubg to the sql and run that query in the access query window to see if it returns the records you expect it could be several things so testing the sql that comes out of your program in the query window is a way to find out if its in the code or in the table you try to access<br />
<br />
----------<br />
bruintje
</div>


Hi ba272,
----------

if it works on some tables and not on others, then why not try to deubg to the sql and run that query in the access query window to see if it returns the records you expect it could be several things so testing the sql that comes out of your program in the query window is a way to find out if its in the code or in the table you try to access

----------
bruintje

<div>
mnasman,<br />
<br />
That worked. &nbsp;I had tried the following:<br />
<br />
and active='true'<br />
<br />
which didn't work as you'd expect, before I'd posted the question.<br />
<br />
Thanks,<br />
Bob
</div>


mnasman,

That worked.  I had tried the following:

and active='true'

which didn't work as you'd expect, before I'd posted the question.

Thanks,
Bob

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have added a column to ab Access table called &quot;Active&quot; and it's a Yes/No field. &nbsp;It's part of my test environment so I can have completed records in the database that my program will ignore, until I check the checkbox to activate the record.<br />
<br />
Oddly it works on some tables but not others. &nbsp;When running in &quot;TestMode&quot; I add the following to each line of SQL.<br />
<br />
&quot;&nbsp;AND Active=1&quot;;<br />
<br />
In other words I'm appending one final condition to my WHERE clause. &nbsp;And like I said, it works on some tables but not others. &nbsp;Any ideas?<br />
<br />
Thanks,<br />
Bob
</div>
</div>


Hi,

I have added a column to ab Access table called "Active" and it's a Yes/No field.  It's part of my test environment so I can have completed records in the database that my program will ignore, until I check the checkbox to activate the record.

Oddly it works on some tables but not others.  When running in "TestMode" I add the following to each line of SQL.

" AND Active=1";

In other words I'm appending one final condition to my WHERE clause.  And like I said, it works on some tables but not others.  Any ideas?

Thanks,
Bob

SQL Problem with Yes/No field in Access

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).