Article View: borland.public.cppbuilder.database.multi-tier
Article #1413Re: Query with Hour
From: pepito perez
Date: Tue, 16 Nov 1999 00:00
Date: Tue, 16 Nov 1999 00:00
34 lines
1502 bytes
1502 bytes
Thank you, but i've tried and it doesn?t work (The same syntax error).
But I have found the solution:
"select count(*) from Users where (format(time,'hh:nn') >=
format('12:10','hh:nn')) "
Thank you, anyway.
CyberNIK <ncs@intsar.com> wrote in message
news:80pq3l$6em10@forums.borland.com...
>
> pepito perez wrote in message <80on09$pom12@forums.borland.com>...
> >I have an application in C++Builder 4.0 which works with an Access
Database.
> >One of the database's table have a date/time field, exactly a short time
> >(17:35) field.
> >
> >I try to launch a query like" select count(*) from Users where time >
> >#17:35#". This sentence works well in Access directly but with a TQuery
> >object it doesn๏ฟฝt work (Syntaxis Error).
> >
>
>
> May be you should use
>
> select count(*) from Users where time > "17:35"
>
> It works fine with date fields with values like "02.03.99"
>
> CyberNIK
>
Technical Details
Message-ID:
<80r77q$ii35@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<80on09$pom12@forums.borland.com> <80pq3l$6em10@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: fcd2b,7a81ff595fef6c57 X-Google-Attributes: gidfcd2b,public From: "pepito perez" <pepito@hotmail.com> Subject: Re: Query with Hour Date: 1999/11/16 Message-ID: <80r77q$ii35@forums.borland.com> X-Deja-AN: 549200248 References: <80on09$pom12@forums.borland.com> <80pq3l$6em10@forums.borland.com> X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Organization: Another Netscape Collabra Server User X-MSMail-Priority: Normal Newsgroups: borland.public.cppbuilder.database.multi-tier