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/>.
>