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
