Article View: borland.public.vdbase.data.sql
Article #146Re: Date field in sql builder
From: Ken Mayer [TeamB]
Date: Thu, 04 Mar 1999 00:00
Date: Thu, 04 Mar 1999 00:00
22 lines
1249 bytes
1249 bytes
"Herman Viaene" <herman.viaene@online.be> wrote:
>Writing something simple like the following does not work in VdB 7.01 SQL
>Designer:
>select * from invoice where order_date > {01/01/1995}
>results in message "Error in criteria row: invalid use of keyword". Field is
>formatted correctly and century is on, what is wrong then.
Bowen's got the right of it, but just to explain a bit more, local SQL
doesn't understand dBASE expressions, dBASE literals like the date you
show above, etc. Local SQL sees dates as character strings, instead
..
Ken
---
Ken Mayer [TeamB]
VdBASE7 Tutorial, HOW TOs, and dUFLP library:
http://www.apptools.com/dbase/kenstuff
(which is a mirror of:)
http://www.mindspring.com/~hirschv/dbase/dbase.htm
TeamB: http://www.teamb.com
Technical Details
Message-ID:
<36ddce30.1329713@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<7bk1bs$2i77@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,9c0ce2ccf9b5c6e5 X-Google-Attributes: gidff5a1,public From: supportInfo@borland.com (Ken Mayer [TeamB]) Subject: Re: Date field in sql builder Date: 1999/03/04 Message-ID: <36ddce30.1329713@forums.borland.com> X-Deja-AN: 450961761 References: <7bk1bs$2i77@forums.borland.com> Organization: Golden Stag Productions Reply-To: teamb@opto-pps.com Newsgroups: borland.public.vdbase.data.sql