Subject FB or D3 Compatibility with FreeUDFLib.dll
Author Kevin Stanton
Greetings,
I am trying to migrate from the original release of OS IB 6.01 to FB,
preferably D3.
(I've just downloaded and installed 1.03)

The following trigger causes the server to hard stop:

CREATE TRIGGER OPEN_INVOICES_BU FOR OPEN_INVOICES
ACTIVE BEFORE UPDATE POSITION 0
as
Declare Variable PDD Integer;
begin

If ((new.duedate is not null)) then
begin
PDD = F_AGEINDAYS(new.duedate, 'now');
If (PDD < -32768) then
PDD = -32768;
If (PDD > 32767) then
PDD = 32767;
new.PastDueDays = PDD;
end
else
new.PastDueDays = 0;

end

---------------------
Update:
---------------------
Seems if I replace 'now' with Current_Date or Current_TimeStamp all is well.

Current_Date is not supported in dialect 1 but Current_TimeStamp appears to
be which is understandable due to the non-existant DATE reference in D1.

Is the above a bug (the incompatibility with 'now') or do I need to go
through the database looking for instances like these and change them to
Current_TimeStamp?

Thanks in advance,
Kevin