Hi,
How would you use Symmetric Key Encryption with CursorAdapter? (if it is possible). I have created a sample database with a table and the symmetric key (in SSMS). So in the SSMS I can use ENCRYPTBYKEY and KEY_GUID to add a record. For example:
Insert into test (column1) values (ENCRYPTBYKEY(KEY_GUID('TestKey'),'New Value'))But if you update the table (from VFP) using Cursor Adapter, would you write the code like above in VFP and the CA would work? And since functions ENCRYPTBYKEY and KEY_GUID are not available to VFP compiler, the code won't even compile. I searched UT (for a few years back) and no mention of key word 'ENCRYPTBYKEY'. Does it mean that Symmetric Key Encryption is not used with VFP applications? TIA for any input.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
