1) When creating my tables what do I use for datatypes
2) What about indexing Do I index on Decypt(field1).
3) What about SQL Do I do Select Decypt(field1), Decypt(field2)…
4) What about select * .
Is it supposed to be this big of a pain or am I just going off in wrong direction
Thanks,
Sammy

Encryption Questions
Pramod Gurunath - MSFT
>I’m sure there is a better way of doing this.
The better way is to get Cryptor from Xitech that does it for you automatically behind the scenes.
http://www.xitech-europe.co.uk/Cryptor.htmlhttp://www.hallogram.com/cryptor/
http://fox.wikis.com/wc.dll Wiki~Cryptor
Kevin Mullican
Tamar
Wolfey305
It means that you can only encrypt\decrypt your data 100 times, and then you have to buy new licenses…
JK..
I was afraid that this was what it meant....... So I wanted semantic clarity. Some websites are really weird. People selling their wares do not bother making their purpose clear in this business. When you walk into a shoe store you know that you won't find a bunch of hats in there. What does "runtime" have to do with a machine Another example: software called Kryptos. No explanation as to what it does whatsoever. I thought it was out of cryptology but does not seem to be the case inferring from GUI they show.
Antonionini
I personally had such ideas fleetingly long time ago and abandoned them as impractical. You will be losing a lot of time in terms of execution and extra coding. Also if you are starting from scratch you will need a lot of visual control for a while. You will have to open some of your tables in a browser to see if the right data is there, if a field has been changed correctly.
What I do now is to encode ids and passwords only in a couple of tables. They are rather short. I may also encode some of the memo fields selectively, perhaps.
In old dBase IV there was an option to have all tables encoded if you turned a switch on. I doubt anybody ever used it.
DerekLakin
I also will have a global variable specifying witch data path to use, that same variable will be used in my encrypt \ decrypt functions. Is if I am using non-encrypted data the encrypt \ decrypt will just return what ever is passed in.
I just feel that basic things like binding a textbox to a data field become a big pain.
I’m sure there is a better way of doing this.
Thanks
Sammy.
igloo iguana
It means that you can only encrypt\decrypt your data 100 times, and then you have to buy new licenses…
JK..
I think it means that if you are distribution your software, packaged with there tool, you can distribute it 100 times. Or buy more licenses.
Sammy
Alan Cameron Wills