Article View: borland.public.vdbase.data.sql
Article #930Problems With Field Named "DATE"!!!!!
From: James L. Johnson
Date: Tue, 07 Jul 1998 00:00
Date: Tue, 07 Jul 1998 00:00
10 lines
1174 bytes
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-mailShow 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