Updating Issue

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 4
Joined: Wed 14 May 2008 23:52

Updating Issue

Post by tandrecht » Thu 15 May 2008 16:40

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?

Posts: 296
Joined: Thu 12 Oct 2006 09:34

Post by Ludek » Thu 15 May 2008 21:11

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

Post Reply