HELP !! vdBase 7 reports with dates data type

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

Article #1317

Back to borland.public.vdbase.data.sql Previous Next

#1317

From: E. Tabone
Date: Fri, 06 Mar 1998 00:00

14 lines
1400 bytes

Can anybody help me to make a report with vdBase 7 using date data type
criteria:
With vdBase 5.5 and previous versions, I could select  rows with something
like that:
"...FOR My_date <= DATE()-30"
With the "new" SQL based vdBase reports, I didn't find an  instruction to
make a similar simple selection.
The date data type SQL instructions  which are described in the CD-ROM
(teach SQL yourself in 21 days) given by Borland seem not to be implemented
in vdBase 7.
Any advice would greatly appreciated.
Thanks
Eric

Technical Details

Message-ID: <6dpor1$hnf$1@news4.isdnet.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 105c7d,2f2134430050e939,start
X-Google-Attributes: gid105c7d,public
X-Google-Thread: fdc53,2f2134430050e939,start
X-Google-Attributes: gidfdc53,public
X-Google-Thread: 1162a5,2f2134430050e939,start
X-Google-Attributes: gid1162a5,public
X-Google-Thread: 15bdfb,2f2134430050e939,start
X-Google-Attributes: gid15bdfb,public
X-Google-Thread: ff5a1,2f2134430050e939,start
X-Google-Attributes: gidff5a1,public
From: "E. Tabone" <etabone@hol.fr>
Subject: HELP !!  vdBase 7 reports with dates data type
Date: 1998/03/06
Message-ID: <6dpor1$hnf$1@news4.isdnet.net>
X-Deja-AN: 331512841
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Newsgroups: borland.public.vdbase.data.sql,borland.public.vdbase.forms,borland.public.vdbase.programming,borland.public.vdbase.reports,comp.databases.visual-dbase