Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ideas for decrypting/encrypting numeric data
Message
From
19/10/2018 10:58:40
 
 
To
19/10/2018 07:23:48
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012 R2
Network:
Windows Server 2012 R2
Database:
Visual FoxPro
Application:
Desktop
Virtual environment:
VMWare
Miscellaneous
Thread ID:
01662625
Message ID:
01662674
Views:
39
Well, that's an interesting concept and definitely would be easier. What do you do though for running reports against the data - you would have to decrypt the entire table into a temp table and then run your queries against it - if I understand your structure correctly.

>In the first iteration we did the same.
>As more fields had to be encrypted and bulk operations and printing were happening often, we went to a different logic: all tables only have 1 encrypted field (can be memo) which gets decrypted into a blank 1:1 related table (or scatter name object). Encrypt/decrypt is done via handcrafted Fll according to the empty table structure bound by name convention to data table in the DBC. As there is only 1 crypt string per table should be more secure.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform