<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16608" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=343575022-02082009><FONT face=Arial size=2>Hi
all.</FONT></SPAN></DIV>
<DIV><SPAN class=343575022-02082009><FONT face=Arial size=2>I have been using
some native DAO controls to talk to an Access DB for some time and now I want to
use ADO in preperation for moving to a later version of
Delphi.</FONT></SPAN></DIV>
<DIV><SPAN class=343575022-02082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=343575022-02082009><FONT face=Arial size=2>For one particular
part I am running a filter on a table. I know this is not the best thing, but
for now I have to keep using it until I can change it.</FONT></SPAN></DIV>
<DIV><SPAN class=343575022-02082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=343575022-02082009><FONT face=Arial size=2>with the DAO control
I can go: ([deleted=false] and (starttm>='1 Mar 2009' or
endtm <='20 Mar 2009') ) and (endtm >='1 Mar 2009')</FONT></SPAN></DIV>
<DIV><SPAN class=343575022-02082009><FONT face=Arial size=2>This works
fine.</FONT></SPAN></DIV>
<DIV><SPAN class=343575022-02082009><FONT face=Arial size=2>HOWEVER, when I use
this in the ADO control it throws an error that arguments are of an unexpected
type, or something like that.</FONT></SPAN></DIV>
<DIV><SPAN class=343575022-02082009><FONT face=Arial size=2>IF I remove the
trailing "and (endtm >='1 Mar 2009')" its fine. However I need
this.</FONT></SPAN></DIV>
<DIV><SPAN class=343575022-02082009><FONT face=Arial size=2>Obviously I should
just use a query and I will, I just need to get this working first THEN I
can change it.</FONT></SPAN></DIV>
<DIV><SPAN class=343575022-02082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=343575022-02082009><FONT face=Arial size=2>Anyone got any
ideas?</FONT></SPAN></DIV>
<DIV><SPAN class=343575022-02082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=343575022-02082009><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=343575022-02082009><FONT face=Arial
size=2>Jeremy</FONT></SPAN></DIV></BODY></HTML>