Article View: borland.public.vdbase.data.sql
Article #260Re: Obtaining Age
From: Ken Mayer [TeamB]
Date: Sun, 20 Dec 1998 00:00
Date: Sun, 20 Dec 1998 00:00
21 lines
1350 bytes
1350 bytes
glightsey@cari.net (Gerald Lightsey) wrote: >Local SQL doesn't seem to want to let me use dBASE functions like FLOOR() >and Val() within its SELECT statement. By the way, I need a VdB 5.6 >solution. Local SQL doesn't understand dBASE expressions/functions. You would need to create a memory variable and pass that to the SQL statement. Since you need a 5.6 solution I can't tell you much ... the local SQL in 5.6 isn't all that great, and I dunno how to get it to do what you need. Ken --- Ken Mayer [TeamB] Golden Stag Productions http://www.mindspring.com/~hirschv/homepage.htm http://www.mindspring.com/~hirschv/dbase/dbase.htm Visual dBASE and InterBase WebRing - http://www.fghoche.com/dbasering.htm TeamB: http://www.inprise.com/newsgroups/teamb/whatisteamb.html
Technical Details
Message-ID:
<367c81a9.30671582@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<MPG.10e4a81d2baa73d39897d4@forums.borland.com> <367b1a23.10660941@forums.borland.com> <MPG.10e60f20e28f90ab9897d5@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,13e5acd5c576586a X-Google-Attributes: gidff5a1,public From: supportInfo@borland.com (Ken Mayer [TeamB]) Subject: Re: Obtaining Age Date: 1998/12/20 Message-ID: <367c81a9.30671582@forums.borland.com> X-Deja-AN: 424121068 References: <MPG.10e4a81d2baa73d39897d4@forums.borland.com> <367b1a23.10660941@forums.borland.com> <MPG.10e60f20e28f90ab9897d5@forums.borland.com> Organization: Golden Stag Productions Reply-To: teamb@opto-pps.com Newsgroups: borland.public.vdbase.data.sql