>I am trying to use the Cipher30.fll to encrypt certain fields in certain tables. My question is where does the code go? Does the .fll file need to be in a certain directory (like my source code directory)? Does it need to be included in my project. Where do I use the function call to encrypt/decrypt these fields on my form? The documentation isn't enough for a rank beginner like myself. Please don't suggest one of the other 3rd party products. This project has no $$$$ to purchase any additional software. Thanks in advance for help. Criss


Criss:

We have cipher in the project but excluded from the exe or app. We place
all libraries in a subdirectory from the executable (Working directory).

To load the libraries we use:

SET LIBRARY TO lib\foxtools, lib\gplib, lib\cipher ADDITITVE

Then to use the encrypt and decrypt we place the functions in the code that access the table

SELECT employee.div, time.trans, employee.dept, employee.empud02, departmt.deptname, ;
employee.name, (time.reg_hr + time.ot_hr) * ;
IIF(EMPTY(time.bill_rate), VAL(decrypt(time.eprate, "rock")),
****

REPLACE time.eprate WITH encrypt(employee.payrate,'rock')

The eprate field is Character 7.

Hope this helps.