LiveCode Forums

Hello everyone

I created a small program with db sqlite, I tested the query with DB Browser for sqlite

SELECT * from TEMPLATE WHERE GRUPPO IN (SELECT GRUPPO from Template GROUP by GRUPPO Having COUNT(GRUPPO)>5);

it works great into DB Browser for sqlite but in livecode gives me error (revdberr, Database Error: near "?": Syntax error)

put "SELECT * from TEMPLATE WHERE GRUPPO IN (SELECT GRUPPO from Template GROUP by GRUPPO Having COUNT(GRUPPO)>5) ;" into dbSQL
put revDataFromQuery(,,dbID,dbSQL) into theData
if theData begins with "revdberr" then
answer warning "Problem2 :"&theData
exit to top
end if

please help me understand the error