[DUG] Can anyone explain this?

[Jeremy Coulter]

Hi all.
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.
 
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.
 
with the DAO control I can go:    ([deleted=false] and (starttm>='1 Mar
2009' or endtm <='20 Mar 2009') ) and (endtm >='1 Mar 2009')
This works fine.
HOWEVER, when I use this in the ADO control it throws an error that
arguments are of an unexpected type, or something like that.
IF I remove the trailing  "and (endtm >='1 Mar 2009')"  its fine. However I
need this.
Obviously I should just use a query and I will, I just need to get this
working first THEN I can change it.
 
Anyone got any ideas?
 
 
Jeremy
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20090803/0053c2af/attachment.html