Subject | Re: [firebird-support] Metaphone UDF |
---|---|
Author | M Tuttle (KS) |
Post date | 2005-01-08T22:18:11Z |
Greetings Daniel,
I followed an article called "Implementing a Soundex Function" By John
Midwinter
It can be found on the IBPhoenix website
http://www.ibphoenix.com/main.nfs?a=ibphoenix&s=1086159161%3A486930&page=ibp_howto4
I created the dll in Delphi as talked about in this article, placed the dll
in the UDF folder and it works great.
I can then use this in my Delphi source as in the following:
'P.LAST_NAME_SB = GETSOUNDBYTES(' + QuotedStr(sLastName) + ')';
or I can use it in FireBirds stored procedures and triggers in the database
as in:
DECLARE VARIABLE iSoundBytes SmallInt;
begin
iSoundBytes = GETSOUNDBYTES(V_ADDRESS1_UPR);
...
end
Check it out. Hollar if you need any assistance.
Mike
I followed an article called "Implementing a Soundex Function" By John
Midwinter
It can be found on the IBPhoenix website
http://www.ibphoenix.com/main.nfs?a=ibphoenix&s=1086159161%3A486930&page=ibp_howto4
I created the dll in Delphi as talked about in this article, placed the dll
in the UDF folder and it works great.
I can then use this in my Delphi source as in the following:
'P.LAST_NAME_SB = GETSOUNDBYTES(' + QuotedStr(sLastName) + ')';
or I can use it in FireBirds stored procedures and triggers in the database
as in:
DECLARE VARIABLE iSoundBytes SmallInt;
begin
iSoundBytes = GETSOUNDBYTES(V_ADDRESS1_UPR);
...
end
Check it out. Hollar if you need any assistance.
Mike
----- Original Message -----
From: "Daniel L. Miller" <dmiller@...>
To: <firebird-support@yahoogroups.com>
Sent: Saturday, January 08, 2005 3:09 PM
Subject: [firebird-support] Metaphone UDF
>
> Does anyone have/know of a metaphone UDF for Firebird?
>
> --
> Daniel
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>