> > 2- 'TODAY' is the default for DATE; what is the default for TIME

columns?
What about: current_time

Luiz.

----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, September 20, 2001 6:52 PM
Subject: Re: [IBO] Date Parameter


> > I have a grid that displays a schedule with one date column and another
> time
> > column. The query has in its SQL clause WHERE DATE_COLUMN=:V_DATE_COLUMN
> so
> > that only that date's rows are displayed in the grid, and an
> > IB_DateTimePicker's ParamName is set to V_DATE_COLUMN (its DataSource
> points
> > to the query's datasource).
> >
> > 1- I am obliged to set the DateTimePicker's AlwaysSearch to true,
because
> > otherwise the query will enter edit state whenever the date in the
picker
> is
> > changed. Is this the correct behaviour?
>
> When you change its value it does an update to the current record. This is
> expected behavior and what it is designed to do.
> If you are using it to select a date to provide a subset of records then
you
> have done the recommended thing.
>
> > 2- 'TODAY' is the default for DATE; what is the default for TIME
columns?
>
> 'NOW' - 'TODAY' perhaps?
>
> I really don't know if that will work but you can try it.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>