>>>if I encrypt a memo field in a table using vfpencryption.fll
>>>what is the best way to show the data in a screen? what method is best to handle the derypt/encrypt functions?
>>>
>
>>
>>that really depends on how you code. One way would be to decrypt it when you query the data. Another way would be to decrypt it in your Business Object code. Yet another way would be to decrypt it in the control's refresh. Or if your form has a method that always gets called when a new record is displayed you could use that.
>
>i think it should be in the UI so only a person having access to a particular form can actually have it decrypted.
>using that logic if I decrypt in the gotfocus() it displays plain text (good)
>then if I encrypt it in the lostfocus() it' be encrypted when saved bau also the display shows garbage
>
>to refine my question, is there a way in a edit control to ALWAYS show text while the actual data behind is encrypted??
>
>
>Peter
Personally I'd base my query string on the user's access rights - if he has rights to see the data then unencrypt during the query and encrypt during save. That way he sees the correct data at all times.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________