Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread creating an encrypted table
Fri, Jul 9 2010 9:22 AMPermanent Link

Jon Bondy

I looked through the DBISAM 4 manual for perhaps 30 minutes, and while I can find information about how to access an encrypted table, I cannot find an example of how to create such a table.  Could someone please provide a simple set of sample code?

Thanks!

Jon
Fri, Jul 9 2010 10:07 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Jon


Have a look at DBSys - it has the necessary to create an encrypted table, and you already have the source.

Roy Lambert [Team Elevate]
Fri, Jul 9 2010 12:41 PMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Jon

In addition to what Roy said about using DBSys, that you may use to
create your tables, here is some additional information about creating
tables at runtime :

Encrypted tables are created the same way normal tables are created,
either using TDBISAM.CreateTable method or SQL DDL statement CREATE TABLE .

=> If using TDBISAM.CreateTable method, loot at:

http://www.elevatesoft.com/manual?action=viewmethod&id=dbisam4&product=d&version=7&comp=TDBISAMTable&method=CreateTable

and please note the  NewEncrypted and  NewPassword parameters, used to
indicate if the table is to be encrypted and what shall be used as
encryption password.


=> If you want to use SQL then look at:

http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=d&version=7&topic=CREATE_TABLE_Statement

and note the optional ENCRYPTED WITH clause, that you may use to both
indicate that the table should be created encrypted and what password to
use.


--
Fernando Dias
[Team Elevate]
Fri, Jul 9 2010 8:41 PMPermanent Link

Gregory Sebastian

Hi Jon,
Use the Database System Utility to create your table and encrypt it with the
graphical user interface. Then use the Reverse Engineer feature in the
Database System Utility to generate the code and study it.  With the Reverse
Engineer feature, you can choose either the Delphi Code or SQL code.

Regards
Gregory Sebastian
Image