🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Problems With Field Named "DATE"!!!!!

#930
From: James L. Johnson
Date: Tue, 07 Jul 1998 00:00
10 lines
1174 bytes
I am currently writing an application to access an old DBASE III .DBF
file.  Unfortunately, the programmer who designed the original database
named a date-field with the name DATE!  Pretty lame on his part if you
ask me, but that's another story.  Anyway, I need to preform an SQL
query on the date field, but when I attempt to use the WHERE clause
using the date-field named DATE, I receive the error message "Invalid
Use Of SQL Keyword DATE."  Of course, this makes perfect sense to me,
but does anyone out there know "how" to circumvent the field-name and
use a pseudo-name to specify the date-field in the query even though
it's named "DATE" in the database???
Technical Details
Message-ID: <35A1E55E.6FD67A36@lightspeed.net>
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,ab0a17351dc2485b,start
X-Google-Attributes: gidff5a1,public
From: "James L. Johnson" <cdr@lightspeed.net>
Subject: Problems With Field Named "DATE"!!!!!
Date: 1998/07/07
Message-ID: <35A1E55E.6FD67A36@lightspeed.net>
X-Deja-AN: 369172026
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
Organization: CDR
Mime-Version: 1.0
Reply-To: cdr@lightspeed.net
Newsgroups: borland.public.vdbase.data.sql