DECRYPT

From Lianjapedia
Jump to: navigation, search

Purpose

Decrypt the specified table or tables

Syntax

DECRYPT <.dbf> | <skeleton> KEY <expC1>

See Also

APPEND FROM, COPY FILE, COPY STRUCTURE, COPY, CRC32(), DES3_DECRYPT(), DES3_ENCRYPT(), DIR, ENCRYPT, MD5(), MD5FILE(), SHA1(), SHA1FILE(), SET ENCRYPTION, USE

Description

The DECRYPT command is used to decrypt the data in the specified table, <.dbf> or tables matching the <skeleton>. The <expC1> must contain the three part comma-separated key used to previously encrypt the table. The key may optionally be enclosed in angled brackets. The <skeleton> syntax can only be used if all tables matching the <skeleton> have the same key.

The DECRYPT command decrypts the data and removes the table's .dkf file. After decryption, the key need no longer be specified to gain access to the table.

Example

decrypt accounts key "key1,key2,key3"
decrypt salaries key "<key_1,key_2,key_3>"
 
// decrypt all .dbf files in the directory
decrypt *.dbf key "key1,key2,key3"