>>A client wants to do encryption on database level (Transparent Data Encryption (TDE)).
>>
>>One question that comes up is, if we need to do any changes in our client application, or that is done only on the database without any need of adaptions on the queries or database connection?
>>
>>we are using SQLSTRINGCONNECT and SQLEXEC in VFP with the Standard SQL ODBC driver.
>
>AFAIK the data is "transparently" encrypted and decrypted, so all your code will work without any changes.


Thanks, yes that is also how I understand it, but it would be too simple to be true? I just want to be careful not to promise anything and then we are liable to make it work.