Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread MD5
Tue, Sep 25 2018 8:10 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

I currently use the MD5 hash from synapse - just as a duplicate checking tool for emails rather than security. Until now I've been able to just use it in Delphi but now I want to use it in an sql trigger.

Before I add synapses function to my external functions dll has anyone implemented it in SQL?


Roy Lambert
Tue, Sep 25 2018 8:48 AMPermanent Link

Matthew Jones

Roy Lambert wrote:

> has anyone implemented it in SQL?

Would be interesting to see, but the humorous me who should know better says it is easy - just use a lookup table. 8-)

--

Matthew Jones
Tue, Sep 25 2018 9:21 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Matthew

>Would be interesting to see, but the humorous me who should know better says it is easy - just use a lookup table. 8-)

OK - since its easy post it in the extensions NG Smiley

Roy
Wed, Sep 26 2018 3:51 AMPermanent Link

Matthew Jones

Roy Lambert wrote:

> post it in the extensions NG

Okay, uploading now. May take a moment, only a few petabytes to go...

--

Matthew Jones
Wed, Sep 26 2018 4:22 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Matthew


>Okay, uploading now. May take a moment, only a few petabytes to go...

Brilliant - thanks for the chuckle

Roy
Thu, Sep 27 2018 11:43 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< I currently use the MD5 hash from synapse - just as a duplicate checking tool for emails rather than security. Until now I've been able to just use it in Delphi but now I want to use it in an sql trigger.

Before I add synapses function to my external functions dll has anyone implemented it in SQL? >>

You can use the one that comes with EDB, if it will save you any time.  It's in the edbcommon unit, and these are the pertinent properties/methods:

  TEDBDigest = class(TEDBBaseObject)
     public
        constructor Create; virtual;
        property AsString: String read GetAsString write SetAsString;
        property AsAnsiString: AnsiString read GetAsAnsiString write SetAsAnsiString;
        property AsUnicodeString: UnicodeString read GetAsUnicodeString write SetAsUnicodeString;
        property AsBytes: TEDBBytes read FData write SetAsBytes;
        procedure Assign(FromObject: TEDBDigest);
        function Compare(ObjectToCompare: TEDBDigest): Boolean;
     end;

Tim Young
Elevate Software
www.elevatesoft.com
Thu, Sep 27 2018 12:58 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Tim


Thanks

Roy Lambert
Image