Re: Query with Hour

Article View: borland.public.cppbuilder.database.multi-tier

Article #1409

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#1409

From: CyberNIK
Date: Mon, 15 Nov 1999 00:00

11 lines
1385 bytes

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: <80pq3l$6em10@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <80on09$pom12@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: "CyberNIK" <ncs@intsar.com>
Subject: Re: Query with Hour
Date: 1999/11/15
Message-ID: <80pq3l$6em10@forums.borland.com>
X-Deja-AN: 548971870
Content-Transfer-Encoding: base64
References: <80on09$pom12@forums.borland.com>
Content-Type: text/plain; charset="koi8-r"
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier

Reply to Parent Message