Article View: borland.public.intrabuilder.data.sql
Article #85Re: Local SQL and DATE ??
From: Bernt Wold
Date: Thu, 27 Aug 1998 00:00
Date: Thu, 27 Aug 1998 00:00
36 lines
1369 bytes
1369 bytes
This is working great in a Form (jfm) , but I can't get it to work in my
report ??
Where should I write.......
d = new Date();
I also get an Error parameter d not set , and I am not able to set it ??
Bernt
Nettsenteret
Ken Mayer [TeamB] wrote:
> Bernt Wold <bwold@online.no> wrote:
>
> >Is there a way to get the current date from local SQL in my quiery ??
> >
> >My code is something like this...
> >
> >SELECT * FROM "test.db" Where test_dato > XXXXXXXXX
> >
> >What should I write CurrentDate() or ?????
>
> try:
>
> d = new Date();
>
> select * from "test.db" where test_dato > :d
>
> Ken
> ---
> Ken Mayer [TeamB]
> Golden Stag Productions
> http://www.mindspring.com/~hirschv/homepage.htm
> http://www.mindspring.com/~hirschv/dbase/dbase.htm
Technical Details
Message-ID:
<35E5B6E5.7AB0D6B8@online.no>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<35DFFCEA.788EAB3E@online.no> <35e05801.3888651@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 101d9a,95fed6d25ef14723 X-Google-Attributes: gid101d9a,public From: Bernt Wold <bwold@online.no> Subject: Re: Local SQL and DATE ?? Date: 1998/08/27 Message-ID: <35E5B6E5.7AB0D6B8@online.no> X-Deja-AN: 385383255 Content-Transfer-Encoding: 7bit References: <35DFFCEA.788EAB3E@online.no> <35e05801.3888651@forums.borland.com> Content-Type: text/plain; charset=us-ascii Organization: Another Netscape Collabra Server User Mime-Version: 1.0 Newsgroups: borland.public.intrabuilder.data.sql