Article View: borland.public.vdbase.data.sql
Article #931Re: Problems With Field Named "DATE"!!!!!
From: Romain Strieff [TeamB]
Date: Tue, 07 Jul 1998 00:00
Date: Tue, 07 Jul 1998 00:00
16 lines
1349 bytes
1349 bytes
In article <35A1E55E.6FD67A36@lightspeed.net>, cdr@lightspeed.net grudgingly admits... > 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??? > select * from dates d where d.'date' > '01/01/97' -- Romain Strieff [TeamB]
Technical Details
Message-ID:
<MPG.100c042918710b6898af33@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<35A1E55E.6FD67A36@lightspeed.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,ab0a17351dc2485b X-Google-Attributes: gidff5a1,public From: Romain@Do.not.reply.via.e-mail (Romain Strieff [TeamB]) Subject: Re: Problems With Field Named "DATE"!!!!! Date: 1998/07/07 Message-ID: <MPG.100c042918710b6898af33@forums.borland.com> X-Deja-AN: 369178248 References: <35A1E55E.6FD67A36@lightspeed.net> Organization: TeamB Reply-To: teamb@opto-pps.com Newsgroups: borland.public.vdbase.data.sql