I'll just add to my last post, if the field is actually a timestamp then
use { ts 'yyyy-mm-dd hh:nn:ss'}
> -----Original Message-----
> From: delphi-boun...@delphi.org.nz
> [mailto:delphi-boun...@delphi.org.nz] On Behalf Of Jeremy Coulter
> Sent: Monday, 3 August 2009 11:25 a.m.
> To: 'NZ Borland Developers Group - Delphi List'
> Subject: Re: [DUG] Can anyone explain this?
>
> Didn't like that either. Ah well, will just re-write it as an
> SQL as it should be anyway!
>
> Jeremy
>
> -----Original Message-----
> From: delphi-boun...@delphi.org.nz
> [mailto:delphi-boun...@delphi.org.nz] On Behalf Of Michael Rooney
> Sent: 3 August 2009 11:17
> To: NZ Borland Developers Group - Delphi List
> Subject: Re: [DUG] Can anyone explain this?
>
> 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
>
>
> _______________________________________________
> 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
>
_______________________________________________
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
