[DUG] Can anyone explain this?

[Michael Rooney]

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 <jscoulter at 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
>