topic-22027

hag

Posts: 598

Joined: Tue Apr 15, 2008 04:51 PM

Re: ADS function list
Posted: Wed Aug 03, 2011 11:06 PM

copy please

hgoldstein@dslextreme.com

Thank you

Harvey

Francis Barrimbhal

Posts: 4

Joined: Sun Dec 13, 2009 09:23 PM

Re: ADS function list
Posted: Thu Aug 04, 2011 09:37 AM

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

sambomb

Posts: 389

Joined: Mon Oct 13, 2008 11:26 AM

Re: ADS function list
Posted: Thu Aug 04, 2011 10:28 AM

Files uploaded!

http://www.filesonic.com/file/159404690 ... nction.zip

Email: SamirSSabreu@gmail.com
xHarbour 1.2.3 + Fwhh 20.2

Francisco Valério

Posts: 18

Joined: Mon Jan 13, 2014 08:37 PM

Re: ADS function list
Posted: Mon Aug 22, 2016 07:46 PM

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.

reinaldocrespo

Posts: 990

Joined: Thu Nov 17, 2005 05:49 PM

Re: ADS function list
Posted: Mon Aug 22, 2016 10:26 PM

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 (fw): Select all Collapse

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 (fw): Select all Collapse

( 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.

FiveTech Support Forums

Continue the discussion