Magnus Titho wrote:

> Ahmad $arhan **** wrote:
>> General SQL error
>> invalid request BLR at offset 403
>> function EXTRACTDATE is not defined
>> Module name or entrypoint could not be found.
>>
> You have to register the UDF containing this function.

I don't get quite so tidy a message when I set up a new machine - but I do
know straight away - forgot to copy the UDF's :)

Later versions of Firebird have slightly different UDF libraries so the
'registration' made in 1.0.2 may not be the same for 1.5. I'm switching to
versions that don't have the '.dll' in the UDF name so that I can switch
between Windows and Linux transparently.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Firebird - http://www.firebirdsql.org/index.php