|
_______________________________________________________________________________________
Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________
I'm trying to encrypt a 16 byte credit card number and thought I'd try the SQL encrypt function. I found some code on the net that uses a trigger, but can't get my interpretation to work. When I use the encrypt function in an insert statement it works fine, but when I include it in a trigger it fails. Here is the sequence of events:
* Create a test file of 1 field long enough to hold the encrypted form (16+8=32)
CREATE TABLE MXP02(FLD01 CHAR (32 ) for bit data)
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
