Thread View: borland.public.intrabuilder.data.sql
7 messages
7 total messages
Started by Bernt Wold
Sun, 23 Aug 1998 00:00
Local SQL and DATE ??
Author: Bernt Wold
Date: Sun, 23 Aug 1998 00:00
Date: Sun, 23 Aug 1998 00:00
17 lines
814 bytes
814 bytes
Hei.. I am using Intrabulder 1.5 trying to set up an report with som local SQL... 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 ????? Bernt Nettsenteret
Re: Local SQL and DATE ??
Author: Ken Mayer [TeamB]
Date: Sun, 23 Aug 1998 00:00
Date: Sun, 23 Aug 1998 00:00
22 lines
963 bytes
963 bytes
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
Re: Local SQL and DATE ??
Author: Bernt Wold
Date: Mon, 24 Aug 1998 00:00
Date: Mon, 24 Aug 1998 00:00
26 lines
1140 bytes
1140 bytes
Thanks..... 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
Re: Local SQL and DATE ??
Author: 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
Re: Local SQL and DATE ??
Author: Ken Mayer [TeamB]
Date: Fri, 28 Aug 1998 00:00
Date: Fri, 28 Aug 1998 00:00
22 lines
1071 bytes
1071 bytes
Bernt Wold <bwold@online.no> wrote: >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(); Probably in an onOpen event for the query. >I also get an Error parameter d not set , and I am not able to set it ?? Take a look at online help on the parameter array for a query ... Ken --- Ken Mayer [TeamB] Golden Stag Productions http://www.mindspring.com/~hirschv/homepage.htm http://www.mindspring.com/~hirschv/dbase/dbase.htm
Re: Local SQL and DATE ??
Author: Bernt Wold
Date: Sat, 05 Sep 1998 00:00
Date: Sat, 05 Sep 1998 00:00
25 lines
1270 bytes
1270 bytes
I can't find it in the Online help :-( Ken Mayer [TeamB] wrote: > Bernt Wold <bwold@online.no> wrote: > > >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(); > > Probably in an onOpen event for the query. > > >I also get an Error parameter d not set , and I am not able to set it ?? > > Take a look at online help on the parameter array for a query ... > > Ken > --- > Ken Mayer [TeamB] > Golden Stag Productions > http://www.mindspring.com/~hirschv/homepage.htm > http://www.mindspring.com/~hirschv/dbase/dbase.htm
Re: Local SQL and DATE ??
Author: Ken Mayer [TeamB]
Date: Sat, 05 Sep 1998 00:00
Date: Sat, 05 Sep 1998 00:00
13 lines
932 bytes
932 bytes
Bernt Wold <bwold@online.no> wrote: >I can't find it in the Online help :-( Did you look specifically at the query object? The parameter array is a property of that. Ken --- Ken Mayer [TeamB] Golden Stag Productions http://www.mindspring.com/~hirschv/homepage.htm http://www.mindspring.com/~hirschv/dbase/dbase.htm
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads