🚀 go-pugleaf

On Thu, 04 Mar 1999 00:33:57 GMT, supportInfo@borland.com (Ken Mayer
[TeamB]) wrote:

>"Herman Viaene" <herman.viaene@online.be> wrote:
>
>>Writing something simple like the following does not work in VdB 7.01 SQL
>>Designer:
>>select * from invoice where order_date > {01/01/1995}
>>results in message "Error in criteria row: invalid use of keyword". Field is
>>formatted correctly and century is on, what is wrong then.
>
>Bowen's got the right of it, but just to explain a bit more, local SQL
>doesn't understand dBASE expressions, dBASE literals like the date you
>show above, etc. Local SQL sees dates as character strings, instead
>..

And, to take Ken's expansion of Bowen's answer just one step further...

Since the original poster is in Belgium, I would remindhim that local SQL
is not localized. The date portion of DATE and TIMESTAMP literals must be
in the US format, with month before date.

This does not apply to DATE and TIMESTAMP values passed as parameters.

//////////////////////////////////////////////////////////////////////////
Steve Koterski                    "My problem lies in reconciling my gross
Technical Publications            habits with my net income."
INPRISE Corporation                             -- Errol Flynn (1909-1959)
http://www.borland.com/delphi