Article View: borland.public.cppbuilder.database.multi-tier
Article #1406Query with Hour
From: pepito perez
Date: Mon, 15 Nov 1999 00:00
Date: Mon, 15 Nov 1999 00:00
13 lines
946 bytes
946 bytes
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). I don`t know how to write the hour's format. Anybody may help me ? Thank You in advanced.
Technical Details
Message-ID:
<80on09$pom12@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: fcd2b,7a81ff595fef6c57,start X-Google-Attributes: gidfcd2b,public From: "pepito perez" <pepito@hotmail.com> Subject: Query with Hour Date: 1999/11/15 Message-ID: <80on09$pom12@forums.borland.com> X-Deja-AN: 548772364 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