copy please
hgoldstein@dslextreme.com
ADS function list
Re: ADS function list
Thank you
Harvey
Harvey
- Francis Barrimbhal
- Posts: 4
- Joined: Sun Dec 13, 2009 9:23 pm
Re: ADS function list
Please, please send me a copy too... dr.microso@hotmail.com
I am happy and thankful ...
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
dr.microso@hotmail.com
Re: ADS function list
Files uploaded!
http://www.filesonic.com/file/159404690 ... nction.zip
http://www.filesonic.com/file/159404690 ... nction.zip
Email: SamirSSabreu@gmail.com
MSN: SamirAbreu@hotmail.com
Skype: SamirAbreu
xHarbour 1.1.0 + FwXh 8.02
xHarbour 1.2.1 + Fwhh 10.6
MSN: SamirAbreu@hotmail.com
Skype: SamirAbreu
xHarbour 1.1.0 + FwXh 8.02
xHarbour 1.2.1 + Fwhh 10.6
-
- Posts: 16
- Joined: Mon Jan 13, 2014 8:37 pm
Re: ADS function list
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: 918
- Joined: Thu Nov 17, 2005 5:49 pm
- Location: Fort Lauderdale, FL
Re: ADS function list
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:
Notice the script above uses an ADS Store Procedure. You could also use ADSEnableEncryption() + AdsEncryptTable() API functions, as in:
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.
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;
Code: Select all
( cAlias )->( AdsEnableEncryption( "EncryptionPassword" ) )
( cAlias )->( AdsEncryptTable() )
I find it is definitely simpler if using ADS Data Dictionary.
Hope that helps.
Reinaldo.