_SQLite_Query TOP function?

[UnknownWarrior 0]

I couldn't find anyone using this function on the forum, maybe because it isn't an AutoIt function?

I've tried:

_SQLite_Query(-1, "SELECT TOP(1) orderID FROM Table1 ORDER BY orderID;", $hQuery)

Which says the function doesn't exists (top)

and

_SQLite_Query(-1, "SELECT TOP 1 orderID FROM Table1 ORDER BY orderID;", $hQuery)

Which told me there was a syntax error by the "1" (being the TOP).

Am I missing something here? I just want to grab the lowest orderID from my table :/.

(I think I can use QuerySingleRow, but having this as an extra method would be nice).

[jchd 1,007]

Use standard SQL:

SELECT orderID FROM Table1 ORDER BY orderID LIMIT 1;

Edited January 6, 2013 by jchd