🚀 go-pugleaf

On Sat, 04 Apr 1998 11:49:26 +0800, EDDIE SHUM <econshum@netvigator.com>
wrote:

[...]

>1. What is wrong with my following SQL statement:
>
>	SELECT DATE_I_REC FROM PAYMENT_FORM WHERE DATE_I_REC > {15/02/98}
>
>	DATE_I_REC is a date field containing information on dates when
>invoices are received and PAYMENT_FORM is my file.   I have tried other
>combinations but nothing works.

[...]

In local SQL (what the BDE uses for dBASE and Paradox tables), DATE
literals in SQL statements must be in the format MM/DD/YY or MM/DD/YYYY.
Further, to prevent the literal from being mistaken for an arithmetic
calculation, the literal must be enclosed in quotation marks. The curly
braces you use are a dBASE convention, and not usable by the local SQL
parser.

  SELECT DATE_I_REC
  FROM PAYMENT_FORM
  WHERE (DATE_I_REC > "02/15/98")

**************************************************************************
Steve Koterski
Borland International, Inc.
http://www.borland.com/delphi
(Remove the "SPICEDHAM2" from the address. Death to spam-bots!)