Custom Query

I have incurred a fatal error that occurs during the call to _SQLite_GetTable2d. The error occurs when I have a null or unset (not sure what the SQLite terminology is) value in one of the columns of a row of data. The following script will produce the error

#include <SQLite.au3>
#include <SQLite.dll.au3>

Local $hQuery, $aResult, $iRows, $iColumns
_SQLite_Startup ()
_SQLite_Open () ; open :memory: Database
_SQLite_Exec (-1, "CREATE TABLE aTest (a,b,c);")
_SQLite_Exec (-1, "INSERT INTO aTest(a,b,c) VALUES ('no','columns','null');")
_SQLite_Exec (-1, "INSERT INTO aTest(a,c) VALUES ('missing','b');")
If _SQLite_GetTable2d(-1, "SELECT ROWID,* FROM aTest;", $aResult, $iRows, $iColumns) = $SQLITE_OK Then
	_SQLite_Display2DResult($aResult)
EndIf
_SQLite_Exec (-1, "DROP TABLE aTest;")
_SQLite_Close ()
_SQLite_Shutdown ()

If you remove the line:

_SQLite_Exec (-1, "INSERT INTO aTest(a,c) VALUES ('missing','b');")

the script executes as expected.

I narrowed the error down to an internal function call (_SQLite_szStringRead) within the _SQLite_GetTable2d function:

Func __SQLite_szStringRead($iszPtr, $iLen = -1)
	Local $aStrLen, $vszString
	If $iszPtr < 1 Then Return ""
	If $iLen < 1 Then
		If $g_avSafeMode_SQLite[3] < 1 Then $g_avSafeMode_SQLite[3] = DllOpen("msvcrt.dll")
		$aStrLen = DllCall($g_avSafeMode_SQLite[3], "int:cdecl", "strlen", "ptr", $iszPtr)
		If @error Then Return SetError(1, 0, "")
		$iLen = $aStrLen[0] + 1
	EndIf
	$vszString = DllStructCreate("char[" & $iLen & "]", $iszPtr)
	If @error Then Return SetError(2, 0, "")
	Return SetError(0, $iLen, DllStructGetData($vszString, 1))
EndFunc   ;==>__SQLite_szStringRead

In the case of a null or unset value, the line:

If $iszPtr < 1 Then Return ""

should evaluate as true as the value of $iszPtr is always 0. However, this is not the case and I have found that changing the line to:

If $iszPtr < 1 Or $iszPtr = 0 Then Return ""

will fix the problem.

I discovered BUG in Aut2Exe. In latest beta 3.2.11.5 it places into compiled EXE new aditional icon with ordinal name 10 16x16 16 colors (second icongroup seen in reshacker). Note: In 3.2.10 it was OK.

Here is simple script: [code]MsgBox(0,,@AutoItVersion)code When I compile it with AutoIt 3.2.10 it's OK When I compile it AutoIt 3.2.11.5 beta there is new empty second icon and original second/third icons are moved (their position inside EXE is +1) output is shown on pictures a0_10, a0_11

The same result is also with Auto3Wrapper example like that: [code]#AutoIt3Wrapper_icon=my_icon.ico MsgBox(0,,@AutoItVersion)code output is shown on pictures a10, a11

There is more complicated script: [code]#AutoIt3Wrapper_Icon=log_view.ico #AutoIt3Wrapper_useupx=n #AutoIt3Wrapper_run_after=ResHacker.exe -add %out%, %out%, ikony.res _{, #AutoIt3Wrapper_run_after=upx.exe --best --compress-icons=0 "%out%"code where are more my own icons embeded in my EXE and their positions inside EXE compiled by latest beta is wrong. output is shown on pictures l10, l11}

Version column on is outdated in "Create New Ticket" There is "latest" version 3.2.11.2 but in fact latest version should be 3.2.11.5