About This File
I want to present BETA Version of my ADO.au3 UDF.
Support topic is here: http://www.autoitscript.com/forum/index.php?showtopic=180850
This UDF is modifed version of _sql.au3 UDF.
For that I want to thanks : ; Chris Lambert, eltorro, Elias Assad Neto, CarlH
What's New in Version 2.1.19 BETA
Released
2020/11/09 '2.1.19 BETA' . Added: Function: __ADO_EVENT_InternalWrapper() - mLipok . Added: Function: _ADO_EVENT_Wrapper() - mLipok . Changed: Function: _ADO_OpenSchema_* - added checking __ADO_Recordset_IsNotEmpty($oRecordset) - mLipok . Refactored: Function: _ADO_OpenSchema_* - refactored + cleaned - mLipok . Added: New example: ADO_EXAMPLE__Transactions.au3 - mLipok . Renamed: Function: __ADO_ComErrorHandler_InternalFunction() >> __ADO_ComErrorHandler_WrapperFunction() - mLipok . Removed: #AutoIt3Wrapper_Au3Check_Parameters - as should be only in examples - because should not force user to use Au3Check - mLipok . Changed: suplemented/checked "Function Header's" - mLipok 2020/10/18 '2.1.18 BETA' . EXAMPLE: ADO_EXAMPLE__EventHandling.au3 - mLipok 2020/10/18 '2.1.17 BETA' . Added: Function: _ADO_Connection_Create() - Assign __ADO_EVENT__* functions by default - mLipok . Added: Global Const $__g_oADO_EventsHandler - not needed as event function is assigned by default - mLipok . Added: Function: __ADO_EVENT__ExecuteComplete() - mLipok . Added: Function: __ADO_RowAffected() - mLipok . Added: Function: __ADO_EVENTS_ErrorCollectionAnalyzer() - mLipok . Refactored: Function: _ADO_Connection_OpenMSSQL() - mLipok . Refactored: Function: _ADO_Connection_OpenMSSQL_WinAuth() - mLipok . Added: Function: __ADO_EVENTS_ErrorCollectionAnalyzer() - mLipok . Added: Function: _ADO_EVENTS_ShowOnly_InfoMessages() - mLipok . . !!!!! SCRIPT BREAKING CHANGE !!!!! . Removed: Funcion: __ADO_EVENTS_INIT() - mLipok . Removed: Funcion: _ADO_EVENTS_SetUp() - mLipok . Removed: Global $__g_fnFetchProgress - mLipok . Renamed: Function: _ADO_COMErrorHandler() >>> _ADO_COMErrorHandler_Function() - mLipok . 2019/08/11 '2.1.16 BETA' . Added: $oRecordset.Supports($ADO_adMovePrevious) in _ADO_Recordset_ToString() - xrxca . Added: __ADO_MSSQL_CONNECTION_STRING_WinAuth() - mLipok . Added: _ADO_GetDSNList() - mLipok . Changed: _ADO_RecordsetArray_GetContent() - on succes @extended = UBound($aContent) - mLipok . . . !!!!! SCRIPT BREAKING CHANGE !!!!! . Removed: prameter $iAlternateColors from __ADO_RecordsetArray_Display() for compability wiht current AutoIt Version - mLipok . Removed: prameter $iAlternateColors from _ADO_Recordset_Display() for compability wiht current AutoIt Version - mLipok 2017/05/28 '2.1.15 BETA' . Fixed: Function: __ADO_Recordset_IsNotEmpty() - mLipok . Thanks to @Skysnake for reporting . Added: many description to functions - mLipok . Added: many description to functions - thanks to Skysnake . Refactored: _ADO_Recordset_Display - mLipok . Changed: __ADO_Command_IsValid() - return values are now boolean - mLipok . Changed: __ADO_Connection_IsReady() - return values are now boolean - mLipok . Changed: __ADO_Connection_IsValid() - return values are now boolean - mLipok . Changed: __ADO_IsValidObjectType() - return values are now boolean - mLipok . Changed: __ADO_Recordset_IsNotEmpty() - return values are now boolean - mLipok . Changed: __ADO_Recordset_IsReady() - return values are now boolean - mLipok . Changed: __ADO_Recordset_IsValid() - return values are now boolean - mLipok . Changed: __ADO_RecordsetArray_IsValid() - return values are now boolean - mLipok . . 2017/03/20 '2.1.14 BETA' . Changed: Function: _ADO_COMErrorHandler - If @Compiled Then Return ....... - mLipok . Examples: Fixed bug in example for XLS - mLipok . thanks to ViciousXUSMC . https://www.autoitscript.com/forum/topic/180850-adoau3-udf-beta-support-topic/?do=findComment&comment=1307690 . Examples: New Function: _ErrFunc($oError) - mLipok . ; HowTo: use your own COMErrorHandler instead internal ADO.au3 UDF COMError Handler - _ADO_COMErrorHandler . Examples: New Function: _ErrDescription($sDescription = Default) - mLipok . ; store description to use it outsided UDF in your own function . Added: #Au3Stripper_Ignore_Funcs=__ADO_EVENT__* - mLipok . Changed: _ADO_Execute automaticaly check __ADO_Recordset_IsNotEmpty($oRecordset) - mLipok . Changed: Function: _ADO_ConnectionString_Access() - added support for '.accdb' when $sDriver = Default - mLipok . Chnaged: $aRocordset >> $aRecordset - Skysnake . . . !!! REMARK - I'm not sure when this following changes was happend . Removed: Function: _ADO_OpenSchema_Views - MS SQL: Object or provider could not perform requested action - mLipok . REF: https://msdn.microsoft.com/en-US/library/ee275169(v=bts.10).aspx . For all DBMS only this four QueryType are common: . adSchemaColumns, adSchemaIndexes, adSchemaTables, adSchemaProviderTypes . The SchemaEnum values supported by the Microsoft® OLE DB Provider for DB2 and the Microsoft® ODBC Driver for DB2 can be one of the following constants: . adSchemaColumns, adSchemaIndexes, adSchemaTables, adSchemaProviderTypes + adSchemaProcedures + adSchemaProcedureParameters + adSchemaPrimaryKeys . Removed: Function: _ADO_Schema_GetAllViews - as _ADO_OpenSchema_Views() is also removed - mLipok . Changed: Function: __ADO_IsValidObjectType - in case of @error occured, @extended always return $ADO_EXT_INTERNALFUNCTION - mLipok . Changed: Function: _ADO_COMErrorHandler() - parameter $oADO_Error is now passed as ByRef - mLipok . Added: Function INDEX - Skysnake 2016/03/18 '2.1.13 BETA' . Changed: _ADO_COMErrorHandler - now showing also _ADO_UDFVersion() - mLipok . New: Enums: $ADO_ERR_ISNOTREADYOBJECT - mLipok . Renamed: Function: __ADO_Connection_IsOpen >> __ADO_Connection_IsReady - mLipok . Changed: Function: __ADO_Connection_IsReady : new feature checking connection state and seting $ADO_ERR_ISNOTREADYOBJECT - mLipok . New: Function: __ADO_Recordset_IsReady - mLipok . __ADO_Recordset_IsReady is a wrapper for __ADO_Recordset_IsValid . which also check for $oRecordset.state and set $ADO_ERR_ISNOTREADYOBJECT . __ADO_Recordset_IsReady is now used in few functions which uses $oRecordset . Changed: Function: __ADO_Recordset_IsNotEmpty : now using __ADO_Recordset_IsReady instead __ADO_Recordset_IsValid - mLipok . as __ADO_Recordset_IsReady is wrapper for __ADO_Recordset_IsValid . so now __ADO_Recordset_IsNotEmpty checking old and new feature . . !!!!!!!!!!!!!!!!!!!!!!!! . Renamed: _ADO_ERROR_Description >> _ADO_MSDNErrorValueEnum_Description . New: Function: _ADO_GetErrorDescription - mLipok . New: Function: _ADO_ConsoleError - mLipok 2016/03/09 '2.1.12 BETA' . New: Enums: $ADO_ERR_ISCLOSEDOBJECT - mLipok . New: Function: __ADO_Connection_IsOpen - mLipok . __ADO_Connection_IsOpen is a wrapper for __ADO_Connection_IsValid which also check for $oConnection.state and set $ADO_ERR_ISCLOSEDOBJECT . __ADO_Connection_IsOpen is now used in few functions which uses $oConnection . Changed: Function: __ADO_Recordset_IsNotEmpty - checking $oRecordset.state and return $ADO_ERR_ISCLOSEDOBJECT - mLipok . Changed: Function: _ADO_Command_Execute - mlipok . Now return recordset . Changed: ADO_EXAMPLE.au3 - _Example_MSSQL_COMMAND_StoredProcedure() - mLipok . Removed: Function: _ADO_Connection_OpenJet - mLipok . Look for: _ADO_Connection_OpenConString or _ADO_ConnectionString_Excel 2016/03/08 '2.1.11 BETA' . New: Function: _ADO_OpenSchema_Catalogs - mLipok . New: Function: _ADO_OpenSchema_Tables - mLipok . New: Function: _ADO_OpenSchema_Columns - mLipok . New: Function: _ADO_OpenSchema_Indexes - mLipok . New: Function: _ADO_OpenSchema_Views - mLipok . New: Function: _ADO_Schema_GetAllCatalogs - mLipok . New: Function: _ADO_Schema_GetAllTables - mLipok . New: Function: _ADO_Schema_GetAllViews - mLipok . Removed: Function: _SQL_GetTableName - mLipok . Removed: Function: _ADO_Connection_OpenExcel - mLipok . Look for: _ADO_Connection_OpenConString and _ADO_ConnectionString_Excel . Changed: ADO_EXAMPLE.au3 - _Example_MySQL() - mLipok . Changed: ADO_EXAMPLE.au3 - _Example_PostgreSQL() - mLipok . Renamed: Function: _ADO_Command >> _ADO_Command_Create - mLipok . Changed: Function: _ADO_Command_Create: Parameters removed - $sQuery - mLipok . New: Function: _ADO_Command_CreateParameter - mlipok . New: Function: _ADO_Command_Execute - mlipok . . Added: ADO_EXAMPLE.au3 - _Example_MSSQL_COMMAND_StoredProcedure() - mLipok
.thumb.png.82dc9d6dc958dcab3f977d6fefcf7ef4.png)
