Subject Re: *Problems with UDF
Author viruxfr54
hi geoff,

The two database is in dialect 3.

thanks for your help

-- In, Geoff Worboys <geoff@t...> wrote:
> > The dskudf.dll is in the correct directory location (udf in
> > firebird installation directory), and the function work with
> > an other DB in the same server.
> Hi virux,
> Is it possible that the difference is in the SQL dialect of
> the databases?
> That is; data type DATE is actually a timestamp (64bit
> value) in dialect 1, but it is a date (32bit value) in d3.
> Your example from the problem database seems to indicate
> that it may be a dialect 1 database (it is showing a time
> part for the field, even if it is zero).
> --
> Geoff Worboys
> Telesis Computing