General information
Category:
Coding, syntax & commands
Raj,
>I am doing this for encrypting the data:
>
>select keytbl
>REPLACE ALL lickey WITH Encrypt(lickey, lcEncryptPassword)
CIPHER50 is a reversable encryption algorithm. Therefore, if you encrypt...
lcEncryptedString=ENCRYPT("myString","myPassword")
you would typically unencrypt like this...
lcPlainText=DECRYPT(lcEncryptedString,"myPassword")
However, you could also unencryt like this...
lcPlainText=ENCRYPT(lcEncryptedString,"myPassword")
Notice I used the "ENcrypt" command to decrypt.
What you may have done is issue your REPLACE command more than once, and therefore the "lickey" field in the table may be holding a plaintext data value instead of an encrypted string.
I would recommend starting from scratch and going one step at a time and use the debugger to check your values each step. It's simple, once you see what's happening.
Guy
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only