Devart Forums

I have a Delphi based client/server system hooked up to a MSSQL database and am trying to set up the database so I can encrypt data before I pass it into the database (We don't trust Microsoft's security), then decrypt it on the fly when a user requests it. Encrypting and storing works fine, that is a separate application only used internally, but decrypting is a problem. Currently, when I pull data back to my TMSQuery, update to decrypt it, and return it to the client, it also posts the decrypted values back to the database as well. Any suggestions on what I can do to get the data back to the client without saving to the database?

If you set cachedupdates := true, no data will be automatically saved to DB.