Article View: borland.public.vdbase.data.sql
Article #344Re: Any ideas how to make this work?
From: Steve Koterski
Date: Tue, 20 Oct 1998 00:00
Date: Tue, 20 Oct 1998 00:00
25 lines
1890 bytes
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-mailReferences:
<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