🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Any ideas how to make this work?

#344
From: Steve Koterski
Date: Tue, 20 Oct 1998 00:00
25 lines
1890 bytes
On Tue, 20 Oct 1998 14:16:29 -0500, mike <none@notgiven.com> wrote:

[...]

>This was exactly what i was looking for!!!  it works great and I learned
>something. Now all I have to do is learn about a million other thing and
>I'll be able to  convert my programs to vdb7.

Greate to hear you are moving forward again.

Now for a little FYI follow-up...

You can perform arithmetic operations within SQL statements, including
division. To the SQL parser, without the quotation marks the date literal
10/20/1998 looks like 10 divided by 20 divided by 1,998 -- a value that
would be incompatible with a dBASE DATE column. But by enclosing the date
literal in quotations marks, you indicate to the SQL parser that this is
actually a date literal and not a calculation.

//////////////////////////////////////////////////////////////////////////
Steve Koterski                 "What is success in this world? I would say
Technical Publications         it consists of four simple things: to live
INPRISE Corporation            a lot, to love a lot, to laugh a lot, and
http://www.inprise.com/delphi  from it all, to learn a lot."
                                                     -- Richard J. Needham
Technical Details
Message-ID: <3630202b.29838518@forums.inprise.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <362CB185.25FCA8EF@notgiven.com> <3630d1d7.9783294@forums.inprise.com> <362CE18D.C2334D6A@notgiven.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,a104ec5b907376c2
X-Google-Attributes: gidff5a1,public
From: skoterski@NOSPAMinprise.com (Steve Koterski)
Subject: Re: Any ideas how to make this work?
Date: 1998/10/20
Message-ID: <3630202b.29838518@forums.inprise.com>
X-Deja-AN: 403366238
Content-Transfer-Encoding: 7bit
References: <362CB185.25FCA8EF@notgiven.com> <3630d1d7.9783294@forums.inprise.com> <362CE18D.C2334D6A@notgiven.com>
Content-Type: text/plain; charset=us-ascii
Organization: INPRISE Corporation, Technical Publications
Mime-Version: 1.0
Reply-To: skoterski@NOSPAMinprise.com
Newsgroups: borland.public.vdbase.data.sql