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
