I'm not using ADO and can't check this, but if there are no other suggestions maybe try something like:
[deleted=false] and not (starttm<'1 Mar 2009') and not (endtm>'20 Mar 2009') and endtm >='1 Mar 2009' Be sure to check and re-check the logic there is equivalent to your expression. I haven't had enough coffee yet today to be sure. Good luck, - Mike. On 8/3/09, Jeremy Coulter <jscoul...@gmail.com> wrote: > 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 > _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe
