Date field in sql builder

Article View: borland.public.vdbase.data.sql

Article #53

Back to borland.public.vdbase.data.sql Previous Next

#53

From: Herman Viaene
Date: Wed, 03 Mar 1999 00:00

8 lines
811 bytes

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.
Sorry, if this has been asked before

herman.viaene@online.be.removetherubbish

Technical Details

Message-ID: <7bk1bs$2i77@forums.borland.com>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,9c0ce2ccf9b5c6e5,start
X-Google-Attributes: gidff5a1,public
From: "Herman Viaene" <herman.viaene@online.be>
Subject: Date field in sql builder
Date: 1999/03/03
Message-ID: <7bk1bs$2i77@forums.borland.com>
X-Deja-AN: 450857592
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: borland.public.vdbase.data.sql