| Subject | Re: [ib-support] Grave problem with UDFs and DATEs |
|---|---|
| Author | Helen Borrie |
| Post date | 2002-02-06T13:20:57Z |
At 02:11 PM 06-02-02 +0100, Lele Gaifax wrote:
Unfortunately, you are going to have to write new versions of your date UDFs if you are going to use them with Dialect 3 databases. The date types are all new for Dialect 3. For details, read the Migration Guide PDF document that is with the beta docs. You will now be parsing the old DATE type as TIMESTAMP; and DATE becomes a date-only (no time part). Your new UDFs of course will not work with Dialect 1 databases nor pre-6 versions of IB.
H.
All for Open and Open for All
Firebird Open SQL Database ยท http://firebirdsql.org
_______________________________________________________
>Hi all,Lele,
>
>I have a tiny library of UDFs I wrote years ago, and it's still
>working ok. I was even surprised when I discovered that the very same
>binary dll was compatible with IB5, IB6 and FB1.
>
>But a few days ago, needing two more UDFs, I discovered that I'm not
>anymore able to produce a working dll! No matter how I compile the
>thing, the subset of functions related to DATEs fails miserably and
>cause the server to crash!!
Unfortunately, you are going to have to write new versions of your date UDFs if you are going to use them with Dialect 3 databases. The date types are all new for Dialect 3. For details, read the Migration Guide PDF document that is with the beta docs. You will now be parsing the old DATE type as TIMESTAMP; and DATE becomes a date-only (no time part). Your new UDFs of course will not work with Dialect 1 databases nor pre-6 versions of IB.
H.
All for Open and Open for All
Firebird Open SQL Database ยท http://firebirdsql.org
_______________________________________________________