Leaderboard

Since no one thought of it before I would say : _ArrayUnique

#include <Array.au3> Local $aArray_Base[8] = ["1","2","3","1","2","2","5","6"] _ArrayDisplay($aArray_Base, "Base array") $aArray_Base=_ArrayUnique($aArray_Base,0,0,0,0) _ArraySort($aArray_Base) _ArrayDisplay($aArray_Base, "Final array") Edit: removed item count in _arrayunique()

Does this function do what you are after? https://www.autoitscript.com/autoit3/docs/libfunctions/_ArrayUnique.htm

_ArrayUnique() ? Jos

What's with all the hexadecimal?

I always strongly recommend using SQLite Expert (the free version will do) for experimenting/playing/using SQLite databases. One more note: SQLite is by far the most used RDBMS ever but it's a serverless engine; Due to bugs in all networked file locking protocols currently available (including Windows, Linux, Solaris, whatever) it isn't advicable to access an SQLite DB from a network using the bare library (some wrappers overcome this limitation). OTOH, local concurrent access is no problem.

Look into help file. #include <SQLite.au3> #include <SQLite.dll.au3> Local $aResult, $iRows, $iColumns, $iRval _SQLite_Startup() If @error Then MsgBox(16, "SQLite Error", "SQLite.dll Can't be Loaded!") Exit -1 EndIf ConsoleWrite("_SQLite_LibVersion=" & _SQLite_LibVersion() & @CRLF) _SQLite_Open() ; Open a :memory: database If @error Then MsgBox(16, "SQLite Error", "Can't Load Database!") Exit -1 EndIf ;Example Table ; ID | Name | Age ; ----------------------- ; 1 Alice | 43 ; 2 Bob | 28 ; 3 Cindy | 21 If Not _SQLite_Exec(-1, "CREATE TEMP TABLE persons (ID,Name, Age);") = $SQLITE_OK Then _ MsgBox(16, "SQLite Error", _SQLite_ErrMsg()) If Not _SQLite_Exec(-1, "INSERT INTO persons VALUES (1,'Alice','43');") = $SQLITE_OK Then _ MsgBox(16, "SQLite Error", _SQLite_ErrMsg()) If Not _SQLite_Exec(-1, "INSERT INTO persons VALUES (2,'Bob','28');") = $SQLITE_OK Then _ MsgBox(16, "SQLite Error", _SQLite_ErrMsg()) If Not _SQLite_Exec(-1, "INSERT INTO persons VALUES (3,'Cindy','21');") = $SQLITE_OK Then _ MsgBox(16, "SQLite Error", _SQLite_ErrMsg()) ; Query $iRval = _SQLite_GetTable2d(-1, "SELECT * FROM persons;", $aResult, $iRows, $iColumns) If $iRval = $SQLITE_OK Then _SQLite_Display2DResult($aResult) ;~ $aResult looks like this: ;~ ;~ ID Name Age ;~ 1 Alice 43 ;~ 2 Bob 28 ;~ 3 Cindy 21 ;~ ;~ If the dimensions would be switched in _SQLite_GetTable2d the result would look like this: ;~ ;~ Name Alice Bob Cindy ;~ Age 43 28 21 Else MsgBox(16, "SQLite Error: " & $iRval, _SQLite_ErrMsg()) EndIf _SQLite_Close() _SQLite_Shutdown() regards