========================================================================================================
===  Tidy report for :M:\romaSql-1.0.2\romaSql.au3
========================================================================================================

00001    ;-- TIME_STAMP   2017-03-05 19:41:08   v 0.1
00002    
00003    #include-once
00004    #include <Array.au3>
00005    #include 'queryBuilder.au3'
00006    
00007    ; #INDEX# =======================================================================================================================
00008    ; Title .........: SQL Query Builder
00009    ; AutoIt Version : 3.3.14.2
00010    ; Language ......: German
00011    ; Description ...: SQL Query Builder
00012    ; Insperiert of .: doctrine & Laravel
00013    ; Author(s) .....: 4ern.de
00014    ; ===============================================================================================================================
00015    
00016    ; #Commands# =====================================================================================================================
00017    ; $SQL_debug
00018    ; $SQL_connect
00019    ; $SQL_returnType
00020    ; $SQL_setDefaultTable
00021    ; $SQL_setDefaultKey
00022    
00023    ; $SQL_get
00024    ; $SQL_update
00025    ; $SQL_delete
00026    ; $SQL_insertInto
00027    ; $SQL_take
00028    ; $SQL_limit
00029    ; $SQL_table
00030    ; $SQL_select
00031    ; $SQL_distinct
00032    ;
00033    ; $SQL_where
00034    ; $SQL_orWhere
00035    ; $SQL_whereBetween
00036    ; $SQL_whereNotBetween
00037    ; $SQL_whereIn
00038    ; $SQL_whereNotIn
00039    ; $SQL_whereNull
00040    ; $SQL_whereNotNull
00041    ; $SQL_having
00042    ; $SQL_orHaving
00043    ; $SQL_havingBetween
00044    ; $SQL_havingNotBetween
00045    ; $SQL_havingIn
00046    ; $SQL_havingNotIn
00047    ; $SQL_havingNull
00048    ; $SQL_havingNotNull
00049    ; $SQL_groupBy
00050    ; $SQL_orderBy
00051    ; ===============================================================================================================================
00052    
00053    ; #IN PLANNING# =================================================================================================================
00054    ; + Database
00055    ;	- SQL Create Table
00056    ;	- SQL Drop Table
00057    ;	- SQL Truncate Table
00058    ;	- SQL Alter
00059    ;	- SQL View
00060    ; + Aggregates
00061    ; 	- SQL AVG() Function
00062    ; 	- SQL COUNT() Function
00063    ; 	- SQL SUM() Function
00064    ; 	- SQL MAX() Function
00065    ; 	- SQL MIN() Function
00066    ; + SQL Joins
00067    ; 	- SQL INNER JOIN
00068    ; 	- SQL LEFT JOIN
00069    ; 	- SQL RIGHT JOIN
00070    ; + Unions
00071    ; + Oracle Connection
00072    ; + PostgrSQl Connection
00073    ; ===============================================================================================================================
00074    
00075    ; #INTERNAL_USE_ONLY# ===========================================================================================================
00076    ; __4ern_SQL__IsDefault 		;thx BugFix
00077    ; __4ern_SQL_rawQuery
00078    ; __4ern_SQL_raw_getAll
00079    ; __4ern_SQL_raw_getFirst
00080    ; __4ern_SQL__QueryBuilder__table
00081    ; __4ern_SQL__QueryBuilder__SELECT
00082    ; __4ern_SQL__QueryBuilder__WHERE
00083    ; __4ern_SQL__QueryBuilder__groupBy
00084    ; __4ern_SQL__QueryBuilder__Orderby
00085    ; ===============================================================================================================================
00086    
00087    ; #GLOBAL CONSTANTS# ============================================================================================================
00088    ; FUNKTIONS KONSTANTEN
00089    ; ===============================================================================================================================
00090    	$SQL_debug            = __4ern_SQL_Console_startUp
00091    	$SQL_connect          = __4ern_SQL_Connect
00092    	$SQL_returnType       = __4ern_SQL_defReturn
00093    	$SQL_setDefaultTable  = __4ern_SQL__QueryBuilder__setTable
00094    	$SQL_setDefaultKey    = __4ern_SQL__QueryBuilder__setkey
00095    	$SQL_setDatabase	  = __4ern_set_SQL_Connection
00096    
00097    	$SQL_get              = __4ern_SQL_QueryBuilder_get
00098    	$SQL_update           = __4ern_SQL_QueryBuilder_Update
00099    	$SQL_delete           = __4ern_SQL_QueryBuilder_Delete
00100    	$SQL_insertInto       = __4ern_SQL_Query_insert
00101    	$SQL_take	          = __4ern_SQL__QueryBuilder__limit
00102    	$SQL_limit	          = __4ern_SQL__QueryBuilder__limit
00103    	$SQL_table            = __4ern_SQL_Query_table
00104    	$SQL_select           = __4ern_SQL_Query_select
00105    	$SQL_distinct         = __4ern_SQL_Query_distinct
00106    	$SQL_where            = __4ern_SQL_Query_where
00107    	$SQL_orWhere          = __4ern_SQL_Query_orWhere
00108    	$SQL_whereBetween     = __4ern_SQL_Query_whereBetween
00109    	$SQL_whereNotBetween  = __4ern_SQL_Query_whereNotBetween
00110    	$SQL_whereIn          = __4ern_SQL_Query_whereIn
00111    	$SQL_whereNotIn       = __4ern_SQL_Query_whereNotIn
00112    	$SQL_whereNull        = __4ern_SQL_Query_whereNull
00113    	$SQL_whereNotNull     = __4ern_SQL_Query_whereNotNull
00114    	$SQL_having           = __4ern_SQL_Query_having
00115    	$SQL_orHaving         = __4ern_SQL_Query_orHaving
00116    	$SQL_havingBetween    = __4ern_SQL_Query_havingBetween
00117    	$SQL_havingNotBetween = __4ern_SQL_Query_havingNotBetween
00118    	$SQL_havingIn         = __4ern_SQL_Query_havingIn
00119    	$SQL_havingNotIn      = __4ern_SQL_Query_havingNotIn
00120    	$SQL_havingNull       = __4ern_SQL_Query_havingNull
00121    	$SQL_havingNotNull    = __4ern_SQL_Query_havingNotNull
00122    	$SQL_groupBy          = __4ern_SQL__QueryBuilder__groupBy
00123    	$SQL_orderBy          = __4ern_SQL_Query_orderBy
00124    	$SQL_raw			  = __4ern_SQL_rawQueryExpr
00125    
00126    ; #FUNCTION# ====================================================================================================================
00127    ; Author ........: 4ern.de
00128    ; Description....: Return Type
00129    ; ...............: Default: Object Dictionary
00130    ; ...............: Array
00131    ; ===============================================================================================================================
00132  +-func __4ern_SQL_defReturn($ptype = DEFAULT)
00133  |    	Local Static $rType = 'array'
00134  |    	if __4ern_SQL__IsDefault($ptype, '-1,', ',') Then return $rType
00135  |    	if $ptype = 'array' Then $rType = 'array'
00136  |    	if $ptype = 'oDict' Then $rType = 'oDict'
00137  +-endfunc
00138    
00139    ; #FUNCTION# ====================================================================================================================
00140    ; Author ........: 4ern.de
00141    ; Description....: set Default Database
00142    ; ...............: Default: MySQL
00143    ; ===============================================================================================================================
00144  +-func __4ern_set_SQL_Connection($database = 'mysql')
00145  |    	__4ern_SQL_Connection('set', -1, -1, -1, -1, -1, $database)
00146  +-endfunc
00147    
00148    ; #FUNCTION# ====================================================================================================================
00149    ; Author ........: 4ern.de
00150    ; Description....: set Connectionstrings
00151    ; ...............: Default: MySQL
00152    ; ...............: ConnectionString
00153    ;
00154    ; ...............: https://www.connectionstrings.com
00155    ; ===============================================================================================================================
00156  +-func __4ern_SQL_Connection($action = 'getDatabase', $SERVER=NULL, $DB=NULL, $USER=NULL, $PASSWORD=NULL, $DRIVER=NULL, $database=NULL)
00157  |    
00158  |    	local static $databaseDefault
00159  |    
00160  |    	;----------------------------------------------------------------------------------------------/
00161  |    	; setze die Standart Datenbank
00162  |    	;----------------------------------------------------------------------------------------------/
00163  |  +-	if $action = 'set' then
00164  |  |    		$databaseDefault = $database
00165  |  |    		return $databaseDefault
00166  |  +-	endif
00167  |    
00168  |    	;----------------------------------------------------------------------------------------------/
00169  |    	; Übergebe die gesetzte Database
00170  |    	;----------------------------------------------------------------------------------------------/
00171  |    	if $action = 'getDatabase' then return $databaseDefault
00172  |    
00173  |    	;----------------------------------------------------------------------------------------------/
00174  |    	; Übergebe den Connectionstring
00175  |    	;----------------------------------------------------------------------------------------------/
00176  |  +-	if $action = 'getConnectionString' then
00177  |  |  +-		switch $databaseDefault
00178  |  |  |    
00179  |  |  |  +-			case 'mySql'
00180  |  |  |  |    				if __4ern_SQL__IsDefault($DRIVER, '-1,', ',') then _
00181  |  |  |  |  |       					return StringFormat('Driver={MySQL ODBC 5.3 ANSI Driver};Server=%s;Database=%s;User=%s;Password=%s;',$SERVER, $DB, $USER, $PASSWORD)
00182  |  |  |  |    				return StringFormat('Driver={%s};Server=%s;Database=%s;User=%s;Password=%s;',$DRIVER, $SERVER, $DB, $USER, $PASSWORD)
00183  |  |  |  |    
00184  |  |  |  +-			case 'sqlServer'
00185  |  |  |  |    				if __4ern_SQL__IsDefault($DRIVER, '-1,', ',') then _
00186  |  |  |  |  |       					return StringFormat('DRIVER={SQL Server};SERVER=%s;DATABASE=%s;uid=%s;pwd=%s;',$SERVER, $DB, $USER, $PASSWORD)
00187  |  |  |  |    				return StringFormat('DRIVER={%s};SERVER=%s;DATABASE=%s;uid=%s;pwd=%s;', $DRIVER, $SERVER, $DB, $USER, $PASSWORD)
00188  |  |  |  |    
00189  |  |  |  +-			case 'access'
00190  |  |  |  |    				if __4ern_SQL__IsDefault($DRIVER, '-1,', ',') then _
00191  |  |  |  |  |       					return StringFormat('Driver={Microsoft Access Driver (*.mdb)};%s;Uid=%s;Pwd=%s;',$DB, $USER, $PASSWORD)
00192  |  |  |  |    				return StringFormat('Driver={%s};%s;Uid=%s;Pwd=%s;',$DRIVER, $DB, $USER, $PASSWORD)
00193  |  |  |  |    
00194  |  |  |  +-			case 'sqLite'
00195  |  |  |  |    				if __4ern_SQL__IsDefault($DRIVER, '-1,', ',') then _
00196  |  |  |  |  |       					return StringFormat('DRIVER=SQLite3 ODBC Driver;Database=%s;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;',$DB)
00197  |  |  |  |    				return StringFormat('DRIVER=%s;Database=%s;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;', $DRIVER, $DB)
00198  |  |  +-		endswitch
00199  |  +-	endif
00200  +-endfunc
00201    
00202    ; #FUNCTION# ====================================================================================================================
00203    ; Author ........: 4ern.de
00204    ; Description....: MSSQL ADO Connection Object
00205    ; =====================================================================================================================
00206  +-func __4ern_SQL_Connect($pDB = DEFAULT, $pUSER = DEFAULT, $pPASSWORD = DEFAULT, $pSERVER = DEFAULT, $pDRIVER = DEFAULT, $ACTION = DEFAULT)
00207  |    
00208  |    	;----------------------------------------------------------------------------------------------/
00209  |    	; Deklaration
00210  |    	;----------------------------------------------------------------------------------------------/
00211  |    	Global $gO__4ern_SQLError = ObjEvent("AutoIt.Error", "__4ern_SQL_errFunc")
00212  |    	Local Static $oCon, $SERVER = NULL, $DB = NULL, $USER = NULL, $PASSWORD = NULL, $DRIVER, $conInfo = NULL
00213  |    
00214  |    	;----------------------------------------------------------------------------------------------/
00215  |    	; Erstelle ein ADODB Verbindung
00216  |    	;----------------------------------------------------------------------------------------------/
00217  |    	$oCon                   = ObjCreate('ADODB.Connection')
00218  |    	$oCon.ConnectionTimeout = 30
00219  |    
00220  |    	;----------------------------------------------------------------------------------------------/
00221  |    	; Setze DEFAULTS
00222  |    	;----------------------------------------------------------------------------------------------/
00223  |    	IF $ACTION 	  =  DEFAULT THEN $ACTION 	= 'get()'
00224  |    	IF $pDB       <> DEFAULT THEN $DB       = $pDB
00225  |    	IF $pUSER     <> DEFAULT THEN $USER     = $pUSER
00226  |    	IF $pPASSWORD <> DEFAULT THEN $PASSWORD = $pPASSWORD
00227  |    	IF $pSERVER   <> DEFAULT THEN $SERVER   = $pSERVER
00228  |    	IF $pDRIVER   <> DEFAULT THEN $DRIVER   = $pDRIVER
00229  |    
00230  |    	;----------------------------------------------------------------------------------------------/
00231  |    	; Prüfe ob alle Zugangsparameter vorhanden sind.
00232  |    	;----------------------------------------------------------------------------------------------/
00233  |    	$errorLogin = False
00234  |  +-	switch __4ern_SQL_Connection()
00235  |  |  +-		case 'mySql', 'sqlServer'
00236  |  |  |    			If $DB = NULL OR $USER = NULL OR $PASSWORD = NULL OR $SERVER = NULL Then $errorLogin = True
00237  |  |  +-		case 'access'
00238  |  |  |    			If $DB = NULL OR $USER = NULL OR $PASSWORD = NULL Then $errorLogin = True
00239  |  |  +-		case 'sqLite'
00240  |  |  |    			If $DB = NULL Then $errorLogin = True
00241  |  +-	endswitch
00242  |    
00243  |  +-	If ($errorLogin = True) Then
00244  |  |    		__4ern_SQL_Console('error', 'Fehler!', 'Eines der Zugangsparameter´oder der Datenbankpfad wurde nicht angegeben.')
00245  |  |    		return SetError(1)
00246  |  +-	endif
00247  |    
00248  |    	;----------------------------------------------------------------------------------------------/
00249  |    	; Connection Information
00250  |    	;----------------------------------------------------------------------------------------------/
00251  |  +-	if $conInfo == NULL then
00252  |  |    		__4ern_SQL_Console('info', 'Connection String', _
00253  |  |  |       			StringFormat('DATABASE=%s, SERVER=%s, DATABASE=%s, $USER=%s, PW=***, TimeOut=%s', _
00254  |  |  |       				__4ern_SQL_Connection(), $SERVER, $DB, $USER, $oCon.ConnectionTimeout))
00255  |  |    		$conInfo = 1
00256  |  +-	endif
00257  |    
00258  |    	;----------------------------------------------------------------------------------------------/
00259  |    	; Schließe Connection falls diese offen ist.
00260  |    	;----------------------------------------------------------------------------------------------/
00261  |    	if not $oCon.state = 0 then $oCon.close
00262  |    
00263  |    	;----------------------------------------------------------------------------------------------/
00264  |    	; Action
00265  |    	;----------------------------------------------------------------------------------------------/
00266  |  +-	Switch $ACTION
00267  |  |    
00268  |  |    		;----------------------------------------------------------------------------------------------/
00269  |  |    		; Verbindungsaufbau
00270  |  |    		;----------------------------------------------------------------------------------------------/
00271  |  |  +-		Case 'write()'
00272  |  |  |    
00273  |  |  |    			;----------------------------------------------------------------------------------------------/
00274  |  |  |    			; Wenn Objekt erstellt wurde, stelle Verbindung her.
00275  |  |  |    			;----------------------------------------------------------------------------------------------/
00276  |  |  |  +-			If IsObj($oCon) Then
00277  |  |  |  |    				;----------------------------------------------------------------------------------------------/
00278  |  |  |  |    				; Object Mode
00279  |  |  |  |    				;----------------------------------------------------------------------------------------------/
00280  |  |  |  |    				$oCon.Mode = 16
00281  |  |  |  |    
00282  |  |  |  +-			Else
00283  |  |  |  |    				__4ern_SQL_Console('error', '$oCon = ObjCreate', 'ADODB Objekt konnte nicht erstellt werden.')
00284  |  |  |  |    				return SetError(3, '', 0)
00285  |  |  |  +-			EndIf
00286  |  |  |    
00287  |  |  |    		;----------------------------------------------------------------------------------------------/
00288  |  |  |    		; Beende die ADODB Verbindung
00289  |  |  |    		;----------------------------------------------------------------------------------------------/
00290  |  |  +-		Case 'get()'
00291  |  |  |    
00292  |  |  |    			;----------------------------------------------------------------------------------------------/
00293  |  |  |    			; Wenn Objekt erstellt wurde, stelle Verbindung her.
00294  |  |  |    			;----------------------------------------------------------------------------------------------/
00295  |  |  |  +-			If IsObj($oCon) Then
00296  |  |  |  |    				;----------------------------------------------------------------------------------------------/
00297  |  |  |  |    				; Cursor Side
00298  |  |  |  |    				;----------------------------------------------------------------------------------------------/
00299  |  |  |  |    				$oCon.CursorLocation = 3
00300  |  |  |  |    
00301  |  |  |  +-			Else
00302  |  |  |  |    				__4ern_SQL_Console('error', '$oCon = ObjCreate', 'ADODB Objekt konnte nicht erstellt werden.')
00303  |  |  |  |    				return SetError(3, '', 0)
00304  |  |  |  +-			EndIf
00305  |  |  |    
00306  |  |  +-		Case 'reset()'
00307  |  |  |    			$oCon.close
00308  |  |  |    			$conInfo  = NULL
00309  |  |  |    			$SERVER   = NULL
00310  |  |  |    			$DB       = NULL
00311  |  |  |    			$USER     = NULL
00312  |  |  |    			$PASSWORD = NULL
00313  |  |  |    			return
00314  |  +-	EndSwitch
00315  |    
00316  |    	;----------------------------------------------------------------------------------------------/
00317  |    	; SQL Server	 Connection String
00318  |    	;----------------------------------------------------------------------------------------------/
00319  |    	$oCon.Open(__4ern_SQL_Connection('getConnectionString', $SERVER, $DB, $USER, $PASSWORD, $DRIVER))
00320  |  +-	IF @error then
00321  |  |    		__4ern_SQL_Console('error', '$oCon.Open', 'Verbindung zum Server konnte nicht hergestellt werden.')
00322  |  |    		return SetError(2, '', 0)
00323  |  +-	endif
00324  |    
00325  |    	;----------------------------------------------------------------------------------------------/
00326  |    	; Retrun ADO Connection Object
00327  |    	;----------------------------------------------------------------------------------------------/
00328  |    	return $oCon
00329  +-endfunc
00330    
00331    ; #FUNCTION# ====================================================================================================================
00332    ; Author ........: 4ern.de
00333    ; Description....: ADO SQL Execute
00334    ; ===============================================================================================================================
00335  +-func __4ern_SQL_rawQuery($pQuery = DEFAULT, $ACTION = DEFAULT)
00336  |    
00337  |    	;----------------------------------------------------------------------------------------------/
00338  |    	; Local Statics
00339  |    	;----------------------------------------------------------------------------------------------/
00340  |    	Local $oRecordSet, $error
00341  |    
00342  |    	;----------------------------------------------------------------------------------------------/
00343  |    	; DEFAULT
00344  |    	;----------------------------------------------------------------------------------------------/
00345  |    	if ($ACTION = DEFAULT) or ($ACTION = -1) or ($ACTION = '') then $ACTION = 'get()'
00346  |    
00347  |    	;----------------------------------------------------------------------------------------------/
00348  |    	; Erstelle eine Verbindung zur DB
00349  |    	;----------------------------------------------------------------------------------------------/
00350  |  +-	if $ACTION == 'get()' Then
00351  |  |    		$oCon = __4ern_SQL_Connect()
00352  |  +-	else
00353  |  |    		$oCon = __4ern_SQL_Connect(DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, 'write()')
00354  |  +-	endif
00355  |    
00356  |    	if @error or IsObj($oCon) = 0 then return SetError(@error, '', $oCon)
00357  |    
00358  |    	;----------------------------------------------------------------------------------------------/
00359  |    	; FastEscape
00360  |    	;----------------------------------------------------------------------------------------------/
00361  |    	$pQuery = StringReplace($pQuery, '"', "'")
00362  |    	$pQuery = StringReplace($pQuery, '`', '"')
00363  |    	__4ern_SQL_Console('SQL', $pQuery)
00364  |    
00365  |    	;----------------------------------------------------------------------------------------------/
00366  |    	; Führe Query aus
00367  |    	;----------------------------------------------------------------------------------------------/
00368  |    	$oRecordSet = $oCon.Execute($pQuery)
00369  |  +-	if @error Then
00370  |  |    		$error = '4ern SQL Error -- Query konnte nicht ausgefuehrt werden.'
00371  |  |    		__4ern_SQL_Console('error', '$oCon.Execute($pQuery)', 'Query konnte nicht ausgefuehrt werden.')
00372  |  |    		$oCon.close
00373  |  |    		return SetError(@error, '', $oRecordSet)
00374  |  +-	endif
00375  |    
00376  |    	;----------------------------------------------------------------------------------------------/
00377  |    	; Prüfe ob Query Daten enthält
00378  |    	;----------------------------------------------------------------------------------------------/
00379  |  +-	if $action == 'get()' then
00380  |  |  +-		if $oRecordSet.eof Then
00381  |  |  |    			__4ern_SQL_Console('warning', '$oRecordSet.eof Query enthält keine Daten')
00382  |  |  |    			$oCon.close
00383  |  |  |    			return SetError(1, '', 0)
00384  |  |  +-		endif
00385  |  +-	endif
00386  |    
00387  |    	;----------------------------------------------------------------------------------------------/
00388  |    	; Return Switch
00389  |    	;----------------------------------------------------------------------------------------------/
00390  |  +-	Switch $action
00391  |  |    
00392  |  |    		;----------------------------------------------------------------------------------------------/
00393  |  |    		; Übergibt alle Werte
00394  |  |    		;----------------------------------------------------------------------------------------------/
00395  |  |  +-		Case StringInStr($action, 'get()') <> 0
00396  |  |  |    			return __4ern_SQL_raw_getAll($oRecordSet, $oCon)
00397  |  |  |    
00398  |  |  +-		Case StringInStr($action, 'update()') <> 0
00399  |  |  |    			return 1
00400  |  +-	EndSwitch
00401  +-endfunc
00402    
00403    ; #FUNCTION# ====================================================================================================================
00404    ; Author ........: 4ern.de
00405    ; ===============================================================================================================================
00406  +-func __4ern_SQL_raw_getAll($oRecordSet, $oCon)
00407  |    
00408  |    	;----------------------------------------------------------------------------------------------/
00409  |    	; Return Typ
00410  |    	;----------------------------------------------------------------------------------------------/
00411  |    	Local CONST $rType = __4ern_SQL_defReturn()
00412  |    
00413  |    	;----------------------------------------------------------------------------------------------/
00414  |    	; Ermittle die Anzahl der Ergebniss
00415  |    	;----------------------------------------------------------------------------------------------/
00416  |    
00417  |  +-	if $oRecordSet.RecordCount = 1 then
00418  |  |    		return __4ern_SQL_raw_getFirst($oRecordSet, $rType, $oCon)
00419  |  +-	endif
00420  |    
00421  |    	;----------------------------------------------------------------------------------------------/
00422  |    	; Erstellung der Array mit Spaltnamen
00423  |    	;----------------------------------------------------------------------------------------------/
00424  |    
00425  |    		;----------------------------------------------------------------------------------------------/
00426  |    		; Return Typ
00427  |    		;----------------------------------------------------------------------------------------------/
00428  |  +-		Switch $rType
00429  |  |    
00430  |  |    			;----------------------------------------------------------------------------------------------/
00431  |  |    			; Return als Object Dictionary
00432  |  |    			;----------------------------------------------------------------------------------------------/
00433  |  |  +-			Case 'oDict'
00434  |  |  |    
00435  |  |  |    				;----------------------------------------------------------------------------------------------/
00436  |  |  |    				; Haupt Dictionary
00437  |  |  |    				;----------------------------------------------------------------------------------------------/
00438  |  |  |    				Local $oDict = ObjCreate('Scripting.Dictionary')
00439  |  |  |    
00440  |  |  |    				;----------------------------------------------------------------------------------------------/
00441  |  |  |    				; Ermittle Row Key
00442  |  |  |    				;----------------------------------------------------------------------------------------------/
00443  |  |  |    				$oRecordSet = $oRecordSet.Clone
00444  |  |  |    				$rRowKey = __4ern_SQL__QueryBuilder__setTable(-1, -1, 'getTKey')
00445  |  |  |    
00446  |  |  |    				;----------------------------------------------------------------------------------------------/
00447  |  |  |    				; Anzahl der Spalte
00448  |  |  |    				;----------------------------------------------------------------------------------------------/
00449  |  |  |    				$i_Colum = $oRecordSet.Fields.Count
00450  |  |  |    
00451  |  |  |    				;----------------------------------------------------------------------------------------------/
00452  |  |  |    				; Prüfe ob RowKey Colm vorhanden ist.
00453  |  |  |    				; 	--> Wenn nicht vorhanden, werden Zeilennummern als RowKey genutzt
00454  |  |  |    				;----------------------------------------------------------------------------------------------/
00455  |  |  |    				$bColm = false
00456  |  |  |  +-				for $i = 0 to $i_Colum -1
00457  |  |  |  |  +-					if $oRecordSet.Fields($i).Name == $rRowKey then
00458  |  |  |  |  |    						$bColm = True
00459  |  |  |  v--|----						ExitLoop
00460  |  |  |  |  +-					endif
00461  |  |  |  +-				next
00462  |  |  |    
00463  |  |  |    				;----------------------------------------------------------------------------------------------/
00464  |  |  |    				; Erstelle die Spalten
00465  |  |  |    				;----------------------------------------------------------------------------------------------/
00466  |  |  |  +-				for $element in $oRecordSet.Fields
00467  |  |  |  |    					$oDict.add($element.Name, ObjCreate('Scripting.Dictionary'))
00468  |  |  |  +-				next
00469  |  |  |    
00470  |  |  |    				;----------------------------------------------------------------------------------------------/
00471  |  |  |    				; Erstelle ein Dictionary Object
00472  |  |  |    				;----------------------------------------------------------------------------------------------/
00473  |  |  |  +-				while Not $oRecordSet.eof
00474  |  |  |  |    					$rowKey = ($bColm = True) ? $oRecordSet.Fields($rRowKey).Value : $oRecordSet.AbsolutePosition
00475  |  |  |  |  +-					for $element in $oRecordSet.Fields
00476  |  |  |  |  |    						$oDict($element.Name).add($rowKey,$element.Value)
00477  |  |  |  |  +-					next
00478  |  |  |  |    					$oRecordSet.MoveNext
00479  |  |  |  +-				wend
00480  |  |  |    				$oCon.close
00481  |  |  |    				return $oDict
00482  |  |  |    
00483  |  |  |    			;----------------------------------------------------------------------------------------------/
00484  |  |  |    			; Return als Array
00485  |  |  |    			;----------------------------------------------------------------------------------------------/
00486  |  |  +-			Case 'array'
00487  |  |  |  +-				With $oRecordSet
00488  |  |  |  |    					Local $iFields = .Fields.Count
00489  |  |  |  |    					Local $sFields[1][$iFields]
00490  |  |  |  |  +-					for $i = 0 to $iFields -1
00491  |  |  |  |  |    						$sFields[0][$i] = .Fields($i).Name
00492  |  |  |  |  +-					next
00493  |  |  |  |    					$aValue = .GetRows()
00494  |  |  |  +-				Endwith
00495  |  |  |    				_ArrayConcatenate($sFields, $aValue)
00496  |  +-		EndSwitch
00497  |    
00498  |    	;----------------------------------------------------------------------------------------------/
00499  |    	; Retrun Array
00500  |    	;----------------------------------------------------------------------------------------------/
00501  |    	$oCon.close
00502  |    	return $sFields
00503  +-endfunc
00504    
00505    ; #FUNCTION# ====================================================================================================================
00506    ; Author ........: 4ern.de
00507    ; ===============================================================================================================================
00508  +-func __4ern_SQL_raw_getFirst($oRecordSet, $rType, $oCon)
00509  |    
00510  |    		;----------------------------------------------------------------------------------------------/
00511  |    		; Return Typ
00512  |    		;----------------------------------------------------------------------------------------------/
00513  |  +-		Switch $rType
00514  |  |    
00515  |  |    			;----------------------------------------------------------------------------------------------/
00516  |  |    			; Return als Object Dictionary
00517  |  |    			;----------------------------------------------------------------------------------------------/
00518  |  |  +-			Case 'oDict'
00519  |  |  |    				Local $oDict = ObjCreate('Scripting.Dictionary')
00520  |  |  |  +-				for $elemet in $oRecordSet.Fields
00521  |  |  |  |    					$oDict.Add($elemet.Name, $elemet.Value)
00522  |  |  |  +-				next
00523  |  |  |    				$oCon.close
00524  |  |  |    				return $oDict
00525  |  |  |    
00526  |  |  |    			;----------------------------------------------------------------------------------------------/
00527  |  |  |    			; Return als Array
00528  |  |  |    			;----------------------------------------------------------------------------------------------/
00529  |  |  +-			Case 'array'
00530  |  |  |    				Local $array[$oRecordSet.Fields.Count]
00531  |  |  |    				Local $i = 0
00532  |  |  |  +-				for $row in $oRecordSet.Fields
00533  |  |  |  |    					$array[$i] = $row.Value
00534  |  |  |  |    					$i += 1
00535  |  |  |  +-				next
00536  |  |  |    				$oCon.close
00537  |  |  |    				return $array
00538  |  |  |    
00539  |  +-		Endswitch
00540  +-endfunc
00541    
00542    ; #FUNCTION# ====================================================================================================================
00543    ; Author ........: 4ern.de
00544    ; Description....: Console Dubugger
00545    ; ===============================================================================================================================
00546  +-func __4ern_SQL_Console_startUp($mode = 'Console')
00547  |    	__4ern_SQL_Console('set',$mode)
00548  |    	return
00549  +-endfunc
00550  +-func __4ern_SQL_Console($ACTION = DEFAULT, $PTITEL = 'none', $PTXT = 'none')
00551  |    
00552  |    	Local Static $Output = NULL
00553  |    
00554  |    	;----------------------------------------------------------------------------------------------/
00555  |    	; Art der Ausgabe!
00556  |    	;-------------------------------------------------s---------------------------------------------/
00557  |  +-		SELECT
00558  |  |    			;----------------------------------------------------------------------------------------------/
00559  |  |    			; Output to Console
00560  |  |    			;----------------------------------------------------------------------------------------------/
00561  |  |  +-			Case $Output == 'Console'
00562  |  |  |  +-				Switch $ACTION
00563  |  |  |  |  +-					Case 'error'
00564  |  |  |  |  |    						$str = @CRLF & '*** FEHLER - ERROR **************************************************************************************'
00565  |  |  |  |  |    						$str &=  @CRLF & '- Funktion:'&@tab&@tab&$PTITEL
00566  |  |  |  |  |    						$str &=  @CRLF & '- TEXT:'&@tab&@tab&@tab&$PTXT
00567  |  |  |  |  |    						$str &=  @CRLF & '*********************************************************************************************************'
00568  |  |  |  |  |    
00569  |  |  |  |  +-					Case 'warning'
00570  |  |  |  |  |    						$str = @CRLF & '*** Warning *********************************************************************************************'
00571  |  |  |  |  |    						$str &=  @CRLF & '- TEXT:'&@tab&$PTITEL
00572  |  |  |  |  |    
00573  |  |  |  |  +-					Case 'info'
00574  |  |  |  |  |    						$str = @CRLF & '*** Information *****************************************************************************************'
00575  |  |  |  |  |    						$str &=  @CRLF & '- Title:'&@tab&$PTITEL
00576  |  |  |  |  |    						$str &=  @CRLF & '- TEXT:'&@tab&$PTXT
00577  |  |  |  |  |    
00578  |  |  |  |  +-					Case 'SQL'
00579  |  |  |  |  |    						$str = @CRLF & '*** RAW SQL *********************************************************************************************'
00580  |  |  |  |  |    						$str &= @CRLF & '>> '&$PTITEL&' <<'
00581  |  |  |  +-				EndSwitch
00582  |  |  |    				ConsoleWrite($str & @CRLF)
00583  |  |  |    
00584  |  |  |    			;----------------------------------------------------------------------------------------------/
00585  |  |  |    			; SET OUTPUT
00586  |  |  |    			;----------------------------------------------------------------------------------------------/
00587  |  |  +-			Case $ACTION == 'set'
00588  |  |  |    				$Output = $PTITEL
00589  |  |  |    				return
00590  |  +-		ENDSELECT
00591  |    
00592  |    	;----------------------------------------------------------------------------------------------/
00593  |    	; Return
00594  |    	;----------------------------------------------------------------------------------------------/
00595  |    	RETURN
00596  +-endfunc
00597    
00598    ;----------------------------------------------------------------------------------------------/
00599    ; Beschreibung: = Object Error Info
00600    ; @return:      = bool
00601    ; von           = 4ern.de
00602    ;----------------------------------------------------------------------------------------------/
00603  +-func __4ern_SQL_errFunc()
00604  |    	$str = 	StringFormat(StringReplace('! %sr\n\r\n||||||||', '|', '! %-25s%s\r\n'), _
00605  |  |       		"We intercepted a COM Error !", _
00606  |  |       		"err.description is....:", $gO__4ern_SQLError.description, _
00607  |  |       		"err.windescription....:", $gO__4ern_SQLError.windescription, _
00608  |  |       		"err.number is.........:", Hex($gO__4ern_SQLError.number, 8), _
00609  |  |       		"err.lastdllerror is...:", $gO__4ern_SQLError.lastdllerror, _
00610  |  |       		"err.scriptline is.....:", $gO__4ern_SQLError.scriptline, _
00611  |  |       		"err.source is.........:", $gO__4ern_SQLError.source, _
00612  |  |       		"err.helpfile is.......:", $gO__4ern_SQLError.helpfile, _
00613  |  |       		"err.helpcontext is....:", $gO__4ern_SQLError.helpcontext)
00614  |    
00615  |    	__4ern_SQL_Console('error', 'SQL ERROR', $str)
00616  |    	Return 1
00617  +-endfunc
00618    
00619    ; #FUNCTION# ====================================================================================================================
00620    ; Author ........: BugFix
00621    ; ===============================================================================================================================
00622  +-Func __4ern_SQL__IsDefault($var, $sOtherDefaults='-0', $sDelim=Default)
00623  |    	Local $aDef[1] = [0], $match = 0
00624  |    	If IsKeyword($sDelim) Then $sDelim = Opt('GUIDataSeparatorChar')
00625  |    	If $sOtherDefaults <> '-0' Then $aDef = StringSplit($sOtherDefaults, $sDelim, 1)
00626  |    	If Not $aDef[0] Then Return IsKeyword($var)
00627  |  +-	For $i = 1 To $aDef[0]
00628  |  |    		If $var = $aDef[$i] Then $match = 1
00629  |  +-	Next
00630  |    	If Not $match Then Return IsKeyword($var)
00631  |    	Return 1
00632  +-EndFunc

======================
=== xref reports =====
======================

== User functions =================================================================================================
                          Func
Function name             Row     Referenced at Row(s)
========================= ====== ==================================================================================
__4ern_SQL_Connect        00206 
__4ern_SQL_Connection     00156 
__4ern_SQL_Console        00550 
__4ern_SQL_Console_startUp  00546 
__4ern_SQL__IsDefault     00622 
__4ern_SQL_defReturn      00132 
__4ern_SQL_errFunc        00603 
__4ern_SQL_rawQuery       00335 
__4ern_SQL_raw_getAll     00406 
__4ern_SQL_raw_getFirst   00508 
__4ern_set_SQL_Connection  00144 

#### indicates that this specific variable only occurs one time in the script.
---- indicates that this specific variable isn't declared with Dim/Local/Global/Const.

== Variables ======================================================================================================
Variable name             Dim   Used in Row(s)
========================= ===== ===================================================================================
#include                  ----- 00003 00004 00005
$DB                       ----- 00156 00180 00182 00185 00187 00190 00192 00195 00197 00212 00224 00236 00238 00240 
                                00252 00310 00319
$DRIVER                   ----- 00156 00180 00182 00185 00187 00190 00192 00195 00197 00212 00228 00319
$Output                   ----- 00552 00561 00588
$PASSWORD                 ----- 00156 00180 00182 00185 00187 00190 00192 00212 00226 00236 00238 00312 00319
$PTITEL                   ----- 00550 00565 00571 00575 00580 00588
$PTXT                     ----- 00550 00566 00576
$SERVER                   ----- 00156 00180 00182 00185 00187 00212 00227 00236 00252 00309 00319
$SQL_connect              ----- 00091
$SQL_debug                ----- 00090
$SQL_delete               ----- 00099
$SQL_distinct             ----- 00105
$SQL_get                  ----- 00097
$SQL_groupBy              ----- 00122
$SQL_having               ----- 00114
$SQL_havingBetween        ----- 00116
$SQL_havingIn             ----- 00118
$SQL_havingNotBetween     ----- 00117
$SQL_havingNotIn          ----- 00119
$SQL_havingNotNull        ----- 00121
$SQL_havingNull           ----- 00120
$SQL_insertInto           ----- 00100
$SQL_limit                ----- 00102
$SQL_orHaving             ----- 00115
$SQL_orWhere              ----- 00107
$SQL_orderBy              ----- 00123
$SQL_raw                  ----- 00124
$SQL_returnType           ----- 00092
$SQL_select               ----- 00104
$SQL_setDatabase          ----- 00095
$SQL_setDefaultKey        ----- 00094
$SQL_setDefaultTable      ----- 00093
$SQL_table                ----- 00103
$SQL_take                 ----- 00101
$SQL_update               ----- 00098
$SQL_where                ----- 00106
$SQL_whereBetween         ----- 00108
$SQL_whereIn              ----- 00110
$SQL_whereNotBetween      ----- 00109
$SQL_whereNotIn           ----- 00111
$SQL_whereNotNull         ----- 00113
$SQL_whereNull            ----- 00112
$USER                     ----- 00156 00180 00182 00185 00187 00190 00192 00212 00225 00236 00238 00252 00311 00319
$aDef                     ----- 00623 00625 00626 00627 00628
$aValue                   ----- 00493 00495
$action                   ----- 00156 00163 00171 00176 00206 00223 00266 00335 00345 00350 00379 00390 00395 00398 
                                00550 00562 00587
$array                    ----- 00530 00533 00537
$bColm                    ----- 00455 00458 00474
$conInfo                  ----- 00212 00251 00255 00308
$database                 ----- 00144 00145 00156 00164
$databaseDefault          ----- 00158 00164 00165 00171 00177
$element                  ----- 00466 00467 00475 00476
$elemet                   ----- 00520 00521
$error                    ----- 00340 00370
$errorLogin               ----- 00233 00236 00238 00240 00243
$gO__4ern_SQLError        ----- 00211 00604
$i                        ----- 00456 00457 00490 00491 00531 00533 00534 00627 00628
$iFields                  ----- 00488 00489 00490
$i_Colum                  ----- 00449 00456
$match                    ----- 00623 00628 00630
$mode                     ----- 00546 00547
$oCon                     ----- 00212 00217 00218 00252 00261 00276 00280 00295 00299 00307 00319 00328 00351 00353 
                                00356 00368 00372 00382 00396 00406 00418 00480 00501 00508 00523 00536
$oDict                    ----- 00438 00467 00481 00519 00521 00524
$oRecordSet               ----- 00340 00368 00373 00380 00396 00406 00417 00418 00443 00449 00457 00466 00473 00474 
                                00475 00478 00487 00508 00520 00530 00532
$pDB                      ----- 00206 00224
$pDRIVER                  ----- 00206 00228
$pPASSWORD                ----- 00206 00226
$pQuery                   ----- 00335 00361 00362 00363 00368
$pSERVER                  ----- 00206 00227
$pUSER                    ----- 00206 00225
$ptype                    ----- 00132 00134 00135 00136
$rRowKey                  ----- 00444 00457 00474
$rType                    ----- 00133 00134 00135 00136 00411 00418 00428 00508 00513
$row                      ----- 00532 00533
$rowKey                   ----- 00474 00476
$sDelim                   ----- 00622 00624 00625
$sFields                  ----- 00489 00491 00495 00502
$sOtherDefaults           ----- 00622 00625
$str                      ----- 00564 00565 00566 00567 00570 00571 00574 00575 00576 00579 00580 00582 00604 00615
$var                      ----- 00622 00626 00628 00630
0                         ----- 00261 00284 00303 00322 00356 00383 00395 00398 00456 00490 00491 00531 00623 00626 
                                00627
1                         ----- 00145 00245 00255 00345 00383 00399 00417 00444 00456 00489 00490 00534 00616 00623 
                                00625 00627 00628 00631
16                        ----- 00280
2                         ----- 00322
3                         ----- 00284 00299 00303
30                        ----- 00218
8                         ----- 00604
@CRLF                     ----- 00564 00565 00566 00567 00570 00571 00574 00575 00576 00579 00580 00582
@TAB                      ----- 00565 00566 00571 00575 00576
@error                    ----- 00320 00356 00369 00373
ACTION                    00206 00335 00550
AbsolutePosition          ----- 00474
Array                     ----- 00004
Case                      ----- 00179 00184 00189 00194 00235 00237 00239 00271 00290 00306 00395 00398 00433 00486 
                                00518 00529 00561 00563 00569 00573 00578 00587
Clone                     ----- 00443
ConnectionTimeout         ----- 00218 00252
Const                     ----- 00411
Count                     ----- 00449 00488 00530
CursorLocation            ----- 00299
DB                        00156 00212
DRIVER                    00156 00212
Default                   ----- 00132 00206 00223 00224 00225 00226 00227 00228 00335 00345 00353 00550 00622
Else                      ----- 00282 00301 00352
EndFunc                   ----- 00137 00146 00200 00329 00401 00503 00540 00549 00596 00617 00632
EndIf                     ----- 00166 00199 00246 00256 00285 00304 00323 00354 00374 00384 00385 00419 00460
EndSelect                 ----- 00590
EndSwitch                 ----- 00198 00241 00314 00400 00496 00539 00581
EndWith                   ----- 00494
ExitLoop                  ----- 00459
False                     ----- 00233 00455
Fields                    ----- 00449 00466 00475 00488 00520 00530 00532
For                       ----- 00456 00466 00475 00490 00520 00532 00627
Func                      ----- 00132 00144 00156 00206 00335 00406 00508 00546 00550 00603 00622
Global                    ----- 00211
If                        ----- 00134 00135 00136 00163 00171 00176 00180 00185 00190 00195 00223 00224 00225 00226 
                                00227 00228 00236 00238 00240 00251 00261 00276 00295 00320 00350 00356 00369 00379 
                                00380 00417 00457 00624 00625 00626 00628 00630
In                        ----- 00466 00475 00520 00532
Local                     ----- 00133 00158 00212 00340 00411 00438 00488 00489 00519 00530 00531 00552 00623
Mode                      ----- 00280
MoveNext                  ----- 00478
Name                      ----- 00457 00467 00476 00491 00521
Next                      ----- 00461 00468 00477 00492 00522 00535 00629
Not                       ----- 00261 00473 00626 00630
Null                      ----- 00156 00212 00236 00238 00240 00251 00308 00309 00310 00311 00312 00552
Or                        ----- 00236 00238 00356
PASSWORD                  00156 00212
#### PTITEL               00550
#### PTXT                 00550
RecordCount               ----- 00417
Return                    ----- 00134 00165 00171 00180 00182 00185 00187 00190 00192 00195 00197 00245 00284 00303 
                                00313 00322 00328 00356 00373 00383 00396 00399 00418 00481 00502 00524 00537 00548 
                                00589 00595 00616 00626 00630 00631
SERVER                    00156 00212
Select                    ----- 00557
Static                    ----- 00133 00158 00212 00552
#### Static$Output        00552
#### Static$oCon          00212
#### Static$rType         00133
Switch                    ----- 00177 00234 00266 00390 00428 00513 00562
Then                      ----- 00134 00135 00136 00163 00171 00176 00180 00185 00190 00195 00223 00224 00225 00226 
                                00227 00228 00236 00238 00240 00243 00251 00261 00276 00295 00320 00345 00350 00356 
                                00369 00379 00380 00417 00457 00624 00625 00626 00628 00630
To                        ----- 00456 00490 00627
True                      ----- 00236 00238 00240 00243 00458 00474
USER                      00156 00212
Value                     ----- 00474 00476 00521 00533
WEnd                      ----- 00479
While                     ----- 00473
With                      ----- 00487
__4ern_SQL_Connect        ----- 00091
__4ern_SQL_Console_startUp  ----- 00090
__4ern_SQL_QueryBuilder_Delete  ----- 00099
__4ern_SQL_QueryBuilder_Update  ----- 00098
__4ern_SQL_QueryBuilder_get  ----- 00097
__4ern_SQL_Query_distinct  ----- 00105
__4ern_SQL_Query_having   ----- 00114
__4ern_SQL_Query_havingBetween  ----- 00116
__4ern_SQL_Query_havingIn  ----- 00118
__4ern_SQL_Query_havingNotBetween  ----- 00117
__4ern_SQL_Query_havingNotIn  ----- 00119
__4ern_SQL_Query_havingNotNull  ----- 00121
__4ern_SQL_Query_havingNull  ----- 00120
__4ern_SQL_Query_insert   ----- 00100
__4ern_SQL_Query_orHaving  ----- 00115
__4ern_SQL_Query_orWhere  ----- 00107
__4ern_SQL_Query_orderBy  ----- 00123
__4ern_SQL_Query_select   ----- 00104
__4ern_SQL_Query_table    ----- 00103
__4ern_SQL_Query_where    ----- 00106
__4ern_SQL_Query_whereBetween  ----- 00108
__4ern_SQL_Query_whereIn  ----- 00110
__4ern_SQL_Query_whereNotBetween  ----- 00109
__4ern_SQL_Query_whereNotIn  ----- 00111
__4ern_SQL_Query_whereNotNull  ----- 00113
__4ern_SQL_Query_whereNull  ----- 00112
__4ern_SQL__QueryBuilder__groupBy  ----- 00122
__4ern_SQL__QueryBuilder__limit  ----- 00101 00102
__4ern_SQL__QueryBuilder__setTable  ----- 00093
__4ern_SQL__QueryBuilder__setkey  ----- 00094
__4ern_SQL_defReturn      ----- 00092
__4ern_SQL_rawQueryExpr   ----- 00124
__4ern_set_SQL_Connection  ----- 00095
#### aDef                 00623
#### action               00156
#### array                00530
au3                       ----- 00004
close                     ----- 00261 00307 00372 00382 00480 00501 00523 00536
#### conInfo              00212
database                  00144 00156
description               ----- 00604
eof                       ----- 00380 00473
#### error                00340
#### gO__4ern_SQLError    00211
helpcontext               ----- 00604
helpfile                  ----- 00604
#### i                    00531
#### iFields              00488
lastdllerror              ----- 00604
#### match                00623
#### mode                 00546
number                    ----- 00604
oCon                      00406 00508
oDict                     00438 00519
oRecordSet                00340 00406 00508
#### pDB                  00206
#### pDRIVER              00206
#### pPASSWORD            00206
#### pQuery               00335
#### pSERVER              00206
#### pUSER                00206
#### ptype                00132
rType                     00411 00508
#### sDelim               00622
#### sFields              00489
#### sOtherDefaults       00622
scriptline                ----- 00604
source                    ----- 00604
state                     ----- 00261
#### static$databaseDefault  00158
#### var                  00622
windescription            ----- 00604
== Sort Func Names Within #regions =====================================================================
 --------------- Current sequence  ----------------------------------------------------------- 
0000000132   Func __4ern_SQL_defReturn($ptype = Default)
0000000137   EndFunc   ;==>__4ern_SQL_defReturn
0000000144   Func __4ern_set_SQL_Connection($database = 'mysql')
0000000146   EndFunc   ;==>__4ern_set_SQL_Connection
0000000156   Func __4ern_SQL_Connection($action = 'getDatabase', $SERVER = Null, $DB = Null, $USER = Null, $PASSWORD = Null, $DRIVER = Null, $database = Null)
0000000200   EndFunc   ;==>__4ern_SQL_Connection
0000000206   Func __4ern_SQL_Connect($pDB = Default, $pUSER = Default, $pPASSWORD = Default, $pSERVER = Default, $pDRIVER = Default, $action = Default)
0000000329   EndFunc   ;==>__4ern_SQL_Connect
0000000335   Func __4ern_SQL_rawQuery($pQuery = Default, $action = Default)
0000000401   EndFunc   ;==>__4ern_SQL_rawQuery
0000000406   Func __4ern_SQL_raw_getAll($oRecordSet, $oCon)
0000000503   EndFunc   ;==>__4ern_SQL_raw_getAll
0000000508   Func __4ern_SQL_raw_getFirst($oRecordSet, $rType, $oCon)
0000000540   EndFunc   ;==>__4ern_SQL_raw_getFirst
0000000546   Func __4ern_SQL_Console_startUp($mode = 'Console')
0000000549   EndFunc   ;==>__4ern_SQL_Console_startUp
0000000550   Func __4ern_SQL_Console($action = Default, $PTITEL = 'none', $PTXT = 'none')
0000000596   EndFunc   ;==>__4ern_SQL_Console
0000000603   Func __4ern_SQL_errFunc()
0000000617   EndFunc   ;==>__4ern_SQL_errFunc
0000000622   Func __4ern_SQL__IsDefault($var, $sOtherDefaults = '-0', $sDelim = Default)
0000000632   EndFunc   ;==>__4ern_SQL__IsDefault
 --------------- New Sequence      ----------------------------------------------------------- 
0000000131   Func __4ern_set_SQL_Connection($database = 'mysql')
0000000133   EndFunc   ;==>__4ern_set_SQL_Connection
0000000138   Func __4ern_SQL__IsDefault($var, $sOtherDefaults = '-0', $sDelim = Default)
0000000148   EndFunc   ;==>__4ern_SQL__IsDefault
0000000154   Func __4ern_SQL_Connect($pDB = Default, $pUSER = Default, $pPASSWORD = Default, $pSERVER = Default, $pDRIVER = Default, $action = Default)
0000000277   EndFunc   ;==>__4ern_SQL_Connect
0000000287   Func __4ern_SQL_Connection($action = 'getDatabase', $SERVER = Null, $DB = Null, $USER = Null, $PASSWORD = Null, $DRIVER = Null, $database = Null)
0000000331   EndFunc   ;==>__4ern_SQL_Connection
0000000332   Func __4ern_SQL_Console($action = Default, $PTITEL = 'none', $PTXT = 'none')
0000000378   EndFunc   ;==>__4ern_SQL_Console
0000000384   Func __4ern_SQL_Console_startUp($mode = 'Console')
0000000387   EndFunc   ;==>__4ern_SQL_Console_startUp
0000000395   Func __4ern_SQL_defReturn($ptype = Default)
0000000400   EndFunc   ;==>__4ern_SQL_defReturn
0000000407   Func __4ern_SQL_errFunc()
0000000421   EndFunc   ;==>__4ern_SQL_errFunc
0000000426   Func __4ern_SQL_raw_getAll($oRecordSet, $oCon)
0000000523   EndFunc   ;==>__4ern_SQL_raw_getAll
0000000528   Func __4ern_SQL_raw_getFirst($oRecordSet, $rType, $oCon)
0000000560   EndFunc   ;==>__4ern_SQL_raw_getFirst
0000000566   Func __4ern_SQL_rawQuery($pQuery = Default, $action = Default)
0000000632   EndFunc   ;==>__4ern_SQL_rawQuery
== END Sort Func Names Within #Region - #EndRegion =====================================================

