Custom Query


Show under each result:

Results (106 - 108 of 3866)

Ticket Resolution Summary Owner Reporter
#190 Duplicate _SQLite_GetTable2d crashes script if column field is null or unset mims.michael@…

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_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
	$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.

#191 No Bug Aut2Exe adds aditional empty icon into EXE Zedna

I discovered BUG in Aut2Exe. In latest beta 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 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

#192 No Bug Version column on is outdated in "Create New Ticket" Zedna

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

Note: See TracQuery for help on using queries.