Subject Fw: [interbaseworkbench] V1.0.1.1 Params of type date not supported
Author John Peterson
Thanks Kai,
Table in this case is just storing the Date...hence the date type. Also,
if
storing as TimeStamp, there will be a Time component as well......even if
it
is 00:00.00
Have had bad experiences where the time is not quite 0, so cannot compare
date directly, must fiddle with < and >.
IBWB queries the metadata to establish the data type of the other side of
the assignment? in my case job_date = :d.

Hows the machine tool buisiness?...i have repaired boehringer lathes in the
past, and upgraded the control systems.

----- Original Message -----
> From: <WUERZ@...-ingelheim.com>
> To: <jcp@...>
> Sent: Tuesday, December 11, 2001 5:52 PM
> Subject: AW: [interbaseworkbench] V1.0.1.1 Params of type date not
supported
>
>
> Hi John,
> use timestamp ( date is supported in Dialect 1)
>
> Im working with a lot of stored proc's using timestamp.( Also Dialect 3,
> Engine 6.01 , NT)
>
> Regards
> Kai
>
>
> > -----Urspr√ľngliche Nachricht-----
> > Von: John Peterson [SMTP:jcp@...]
> > Gesendet am: Dienstag, 11. Dezember 2001 00:21
> > An: interbaseworkbench@yahoogroups.com
> > Betreff: [interbaseworkbench] V1.0.1.1 Params of type date not
> > supported
> >
> > Hi,
> > Have just tried to put a param of type date in a "where" clause, on the
> > Parameters page this is shown as
> >
> > d date[not supported]
> >
> > snippet of SQL is:
> >
> > where job_date = :d and job <> 0
> >
> > Database is Dialect 3, Engine is 6.01 NT.
> >
> > I vaguely remember trying this in beta times wit hthe same result.
> >
> > Any ideas?....timeframe to fix?
> >
> > Regards
> > John
> >
> >
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> > <http://docs.yahoo.com/info/terms/>.
>