Page 1 of 1

sqlite query error

Posted: Sat Nov 23, 2019 12:30 am
by mdbrna
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 :oops: