🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #167

Re: Date field in sql builder

#167
From: Ivar B. Jessen
Date: Sat, 06 Mar 1999 00:00
45 lines
2382 bytes
On Fri, 05 Mar 1999 22:17:33 GMT, skoterski@NOSPAMinprise.com (Steve
Koterski) wrote:

>On Fri, 05 Mar 1999 21:30:21 GMT, skoterski@NOSPAMinprise.com (Steve
>Koterski) wrote:
>
>This would appear to be a short-coming in how the SQL parser used by the
>32-bit BDE works with these literal values in conjunction with Windows
>system settings.

So VdB did after all not do any hanky-panky. Well I am learning all
the time.

>
>Okay. So here is the rewrite of the date topic for the online help.
>

Thank you. It is good to have official confirmation (and so quickly!)
that use of european dates in the way you describe is not due to a
bug, but is a feature of the BDE which works as designed.
 
>Which one of the two you use is predicated on the Windows
>configuration settings for Date Separator and Short Date Style.

For the unaware user this sentence seems to imply that he must change
the settings in the Windows configuration if he is going to work with
a date format different from the one he is using at the moment. In VdB
date settings are handled by at set of specific commands. Would it be
acceptable to say:

"Which one of the two you use is predicated on the configuration
settings in Windows and/or the BDE-using front-end application."

> A combination of Short Date Style of month before day and a Date
> Separator of anything but a period is not supported in local SQL.

This sentence is difficult to understand as it contains two negations.
Are you saying that only a combination of month before day and a
period as date separator is supported? i.e. MM.DD.YY

>Example of a date literal in a US format:

The examples are fine.

Ivar B. Jessen
Technical Details
Message-ID: <36e19de5.10894564@forums.inprise.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <7bk1bs$2i77@forums.borland.com> <36ddce30.1329713@forums.borland.com> <36e4e115.7047839@forums.inprise.com> <MPG.114868a19e128ae3989fa1@forums.inprise.com> <36e74b65.17766972@forums.inprise.com> <36e05794.2564006@forums.inprise.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,9c0ce2ccf9b5c6e5
X-Google-Attributes: gidff5a1,public
From: bergishagen@vip.cybercity.dk (Ivar B. Jessen)
Subject: Re: Date field in sql builder
Date: 1999/03/06
Message-ID: <36e19de5.10894564@forums.inprise.com>
X-Deja-AN: 452012637
References: <7bk1bs$2i77@forums.borland.com> <36ddce30.1329713@forums.borland.com> <36e4e115.7047839@forums.inprise.com> <MPG.114868a19e128ae3989fa1@forums.inprise.com> <36e74b65.17766972@forums.inprise.com> <36e05794.2564006@forums.inprise.com>
Organization: Another Netscape Collabra Server User
Reply-To: bergishagen@it.dk
Newsgroups: borland.public.vdbase.data.sql