🚀 go-pugleaf

On Fri, 15 Jan 1999 21:24:03 -0700, "John Williamson"
<datam@mail.hubwest.com> wrote:

>have simple select but did not pay attention when there was talk about this
>dates. Here is my line that I have trouble with, it does not like the word
>date
>select * from rppt where date >= mfdate and date <= mtdate
>date is a field in rppt
>mfdate and mtdate are public variables
>I could use a simple filter but would like to take a stab at this sql stuff

The word "DATE" is a keyword in SQL and your use of it conflicts with that.
If you cannot change the name of the column in the table (best choice),
there is a way to use the column with its existing name (second best
choice).

Simply enclose the column name in quotation marks and prefix that with the
name of the table or a table correlation name. Any one of the three
statements below are acceptable.

  SELECT *
  FROM rppt R
  where (R."date" BETWEEN mfdate AND mtdate)

  SELECT *
  FROM rppt 
  where (rppt."date" BETWEEN mfdate AND mtdate)

  SELECT *
  FROM "rppt.dbf"
  where ("rppt.dbf"."date" BETWEEN mfdate AND mtdate)

//////////////////////////////////////////////////////////////////////////
Steve Koterski                      "I do most of my writing sitting down.
Technical Publications              That's where I shine."
INPRISE Corporation                         -- Robert Benchley (1889-1945)
http://www.inprise.com/delphi