..

[69255]

Edited May 1, 2012 by 69255

[jchd]

Make it like this:

#include "SQLite.au3"
If Not _SQLite_Startup() Then Exit
If Not _SQLite_Open("TestMax.db") Then Exit
_SQLite_Exec(-1, "CREATE TABLE if not exists Test ([Name] TEXT, [A] INTEGER, [B] INTEGER);")
_SQLite_Exec(-1, "INSERT INTO Test VALUES ('Floda', 2, 5);")
_SQLite_Exec(-1, "INSERT INTO Test VALUES ('Reltih', 1, 4);")
Local $row
_SQLite_QuerySingleRow(-1, "select Name, max(a, b) as [Maximum value] from test where name like 'flo%';", $row)
_ArrayDisplay($row)
_SQLite_Close()
_SQLite_Shutdown()