Convert Numeric SYS(2007) to text Value

[jester4281]

I am writting a app that stores the individual users password in a numeric code I generate using the SYS(2007, username). This way the password is not 100% visible in the database and only I or someone running the actual program can see the text value.

How can I convert the numeric value to the text value.

Ex. User puts in joedoe it generates 45653, I then want to show th joedoe expression on the form.

 

[baltman]

You cannot back a text input out of a checksum value. All strings evaluate to one of 65,000 is number combinations.

You'd have to store the username (possibly encrypted?). You might want to consider a more complicated function than just a single checksum if you want your app to be truely secure.

Brian

 

[mm0000]

I do not think it is possible since it is not unique for a character expression. Meaning that more than one character expression can generate the same number since there are only 99999 values that can be generated for the universe of character expressions.

You could develop your own encrption algorithm and use the developed logic to display the actual values.

 

[jester4281]

Any Recommindations ?

 

[baltman]

Do a keyword search for encryption. You will find several threads including thread184-602848

Brian

 

[rgbean]

Jester,
For individual fields, check out:
A freeware solution to encryption is the CryptPak by Milan Kosina (

http://milan.jikos.cz/).

Another is CIPHER50.FLL based on work by Tom Rettig and available at the UT (

http://www.universalthread.com/

) in the Download area.

VFP 7.0 & 8.0 have a Crypto API component in the Foundation Classes that uses the MS API encryption.

Rick

 

[pac1exl]

How about the encryption used by some of the programmers in .Net environment, Can I incorporate the same encryption process in my Visual Foxpro program?

 

[wgcs]

Sure... I haven't tried this much, but you can access the Windows Crypto API:

http://fox.wikis.com/wc.dll?Wiki~CryptoAPI

- Bill

Get the best answers to your questions -- See FAQ481-4875.