Custom Query

See ​http://www.autoitscript.com/forum/index.php?showtopic=66284.

The _ArrayMax() function only works on 1 dimentional arrays, but does not return a error if someone tries it with a multi-dimentional array. This results in a crash from within the UDF.

Proposed solution is to add this to line 319 of Array.au3- 'If IsArray($avArray) and UBound($avArray,0)=1 Then' which would make sure the array is single dimentional before attempting to run.

For AutoIt lacks features that allow an application written in AutoIt to connect to a database type of Microsoft Access and interact with it.

FileDelete() does not delete Alternate Data Streams. Here a reproducer.

_Try("~temp.txt:ADS")
_Try("~temp.txt")

Func _Try($sFilename)
	FileWriteLine($sFilename, "This is a Test")
	$Return = FileDelete($sFilename)
	$Error = @error
	ConsoleWrite(@lf&"Filename: " & $sFilename & @LF  & "Filedelete() $Return: " & $Return & "   @error: " & @error & @LF)
	If $Return+$Error= 0 Then ConsoleWrite("*** Bug *** ==> If $Return=0 (no Success), @error should be 1 " &  @LF )
	$Return = _FileDelete($sFilename)
	$Error = @error
	ConsoleWrite("_Filedelete() $Return: " & $Return & "   @error: " & @error & @LF& @LF)
EndFunc   ;==>_Try

Func _FileDelete($sFile)
	$sFile = DllCall('kernel32.dll', 'int', 'DeleteFileW', 'wstr', $sFile)
	Return SetError(Not $sFile[0], 0, $sFile[0])
EndFunc   ;==>_FileDelete

I would recommend to replace FileDelete function by _FileDelete function in my code.