Leaderboard

Using _SQLite_GetTable2d you do obtain a 2D array as result, which you can massage, dissect, display, whatever process at will. Can you explain what you want to do with the result? Note that AutoIt doesn't offer 2D associative arrays. However you can achieve a similar-looking coding style by simply using basic AutoIt features: Enum $_ID, $_name, $_organ_ID, $_x, $_y ; now $_ID = 0, $_name = 1, $_organ_ID = 2, $_x = 3, $_y = 4 ... Local $aRows, $iRows, $iCols _SQLite_GetTable2d($hDB, "select * from organs", $aRows, $iRows, $iCols) ; here check that result isn't empty If Not @error Then For $i = 0 to UBound($aRows) - 1 ConsoleWrite("Row " & $i & " ID = " & $aRows[$i][$_ID] & @LF) ConsoleWrite("Row " & $i & " name = " & $aRows[$i][$_name] & @LF) ConsoleWrite("Row " & $i & " organ_ID = " & $aRows[$i][$_organ_ID] & @LF) ConsoleWrite("Row " & $i & " x = " & $aRows[$i][$_x] & @LF) ConsoleWrite("Row " & $i & " y = " & $aRows[$i][$_y] & @LF) Next EndIf ...