FiveTech Software tech support forums

i LIKE TO CRIPT AND DECRIPTA A DBF FILE FOR USE IT ONLY FROM FWH APPLICATION

ANY IDEA ?

Silvio:

The SIX driver has the following functions:
Sx_DbfEncrypt()
Sx_DbfDecrypt()
This RDD does the rest for you. I used it under DOS without problems. xHarbour (commercial) supports it.

but this cript and decript all records I wish cript only one field of a record

Sylvio:

Clipper or Clipper Tools use to have the CRYPT() function. Check if it has been implemented in xHarbour. Also the SIX RDD have the Sx_decrypt() function.

Silvio,

in xHarbour there is a function called crypt ()

Code: Select all  Expand view

Crypt( <cString>, <cPassWord> ) --> cResult
 

You can save the crypted value to the field an decrypt it on reading

Code: Select all  Expand view

dbf->field := Crypt ("String", cPassword)

and

value := Crypt (dbf->field, cPassword)

ok but then to decript it ?

Please search FIVEWIN samples for "Crypt" and you find working samples.
Regards,
Otto

Silvio wrote:ok but then to decript it ?

with the same command

Code: Select all  Expand view

cCrypt  := Crypt ("String", cPassword)  // crypt string

cDecrypt := Crypt (cCyrpt, cPassword) // decrypt string

I believe the SIX RDD has built-in, optional, encryption. I have not used it so I can't be of any further help on this.

Regards,
James

S,

The best solution -> ADS. You don't reinginiering, and it's free for local mode.

Silvio
I agree with Carles, ADS is the best solution for encripted database.
ADS is easy to learn; almost 100% compatible with your code and DBF files.

The ADS Data Dictionary is an advanced tool (also free), that includes also SQL, at the same level that most expensive relational databases.

Regards


George