--- In IBObjects@yahoogroups.com, Ólafur Guðmundsson <og@v...> wrote:

> Hi Helen, do you have a suggestion on this?
>
> I'm going to implement encryption of my data so that it will not

be readable

> to the sysdba on database level.
>
> I'm using TIB_Transaction, TIB_Datasource, TIB_Query and a

TIB_RichEdit

> control.
>
> I would like to do the encryp. in my app so it will be sent encry.

to the

> server.
>
> Where / in what event do I encrypt the data and where do I decrypt

back the

> data before it will show in the RichEdit control ?

I'm doing some encryption of data although not on a record-by-record
basis that you need. I have some system variables (like number of
users, license type, expiry date, etc.) stored in a system table
which I grab on program invocation. It is encrypted and also
converted to Base64 since that limits the string characters to A-Z,0-
9,\ (which removes nasty characters like the ' (quote) which could
mess-up any manually generated SQL string. So I have to
Base64::decrypt followed by another decryption process before
storing the values in program variables.
As one user suggested, BeforePost and AfterScrolls are good places
to do the encryption/decryption. Be warned that Open() does not
sometimes fire the Scroll events. You have to explicitly call First
(). I can't remember the instances where the Scroll events are not
fired, but to be safe you must call First(). Also be warned that the
Scroll events are broken as per my discussions with Geoff and Jason
on this forum some months ago. To my knowledge they have not been
fixed.

HTH, Eric.