ADS function list

hag
Posts: 598
Joined: Tue Apr 15, 2008 4:51 pm
Location: LOs Angeles, California
Contact:

Re: ADS function list

Post by hag »

Thank you
Harvey
User avatar
Francis Barrimbhal
Posts: 4
Joined: Sun Dec 13, 2009 9:23 pm

Re: ADS function list

Post by Francis Barrimbhal »

Please, please send me a copy too... :roll: dr.microso@hotmail.com
I am happy and thankful ...
"Es como una especie de alquimia: las porciones de código se puede transmutar en ciertas soluciones, sorpresa, sonrisas y con frecuencia se materializan en objetos tales como equipo que uso para escribir estas palabras..."
dr.microso@hotmail.com
User avatar
sambomb
Posts: 385
Joined: Mon Oct 13, 2008 11:26 am
Location: Itaocara - RJ - Brasil
Contact:

Re: ADS function list

Post by sambomb »

Email: SamirSSabreu@gmail.com
MSN: SamirAbreu@hotmail.com
Skype: SamirAbreu
xHarbour 1.1.0 + FwXh 8.02
xHarbour 1.2.1 + Fwhh 10.6
Francisco Valério
Posts: 16
Joined: Mon Jan 13, 2014 8:37 pm

Re: ADS function list

Post by Francisco Valério »

I'm working with ADS , but I'm hard of encrypted tables with .adt extension. Someone uses table encryption in ADS and tell me how the process was conducted.
User avatar
reinaldocrespo
Posts: 918
Joined: Thu Nov 17, 2005 5:49 pm
Location: Fort Lauderdale, FL

Re: ADS function list

Post by reinaldocrespo »

Hello Francisco;

If these tables are Data Dictionary bound tables, as I suspect they are, then you only need to set the encryption password on the dictionary and then enable encryption for the table in question.

Below is a short SQL script that enables encryption for all tables on a data dictionary:

Code: Select all

DECLARE EncryptTables CURSOR as 
              SELECT * 
                FROM System.Tables 
               WHERE table_encryption = 0; 
OPEN EncryptTables; 

WHILE FETCH EncryptTables DO 
     EXECUTE PROCEDURE sp_ModifyTableProperty([EncryptTables].[Name],'TABLE_ENCRYPTION','TRUE','APPEND_FAIL',NULL); 
END WHILE; 

CLOSE EncryptTables;
 
Notice the script above uses an ADS Store Procedure. You could also use ADSEnableEncryption() + AdsEncryptTable() API functions, as in:

Code: Select all

( cAlias )->( AdsEnableEncryption( "EncryptionPassword" ) )
( cAlias )->( AdsEncryptTable() )
 
FYI - it is also possible to encrypt a single record on a table.

I find it is definitely simpler if using ADS Data Dictionary.

Hope that helps.


Reinaldo.
Post Reply