Article View: borland.public.vdbase.data.sql
Article #112Re: Dates me to
From: Geoff S. Wass
Date: Sat, 16 Jan 1999 00:00
Date: Sat, 16 Jan 1999 00:00
15 lines
963 bytes
963 bytes
John, The word 'date' is a reserved word. If you avoid reserved words as field names (etc.) you should. In your case, if you need to keep this field name, then it should be enclosed in quotation marks so that the command is intrepretted correctly. select * from rppt where 'date' >= mfdate and 'date' <= mtdate -- Geoff Wass Kuala Lumpur, Malaysia =>=> More dBASE info at http://members.theglobe.com/Geoff_Wass <=<=
Technical Details
Message-ID:
<36A02705.EFF650F3@ibm.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<77p454$4l01@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,2e2d582e6be9dacb X-Google-Attributes: gidff5a1,public From: "Geoff S. Wass" <gswass@ibm.net> Subject: Re: Dates me to Date: 1999/01/16 Message-ID: <36A02705.EFF650F3@ibm.net> X-Deja-AN: 433237341 Content-Transfer-Encoding: 7bit References: <77p454$4l01@forums.borland.com> X-Accept-Language: en Content-Type: text/plain; charset=us-ascii Organization: Noordindarus Consultancy Sdn. Bhd. Mime-Version: 1.0 Newsgroups: borland.public.vdbase.data.sql