sqlite query error

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, robinmiller, kevinmiller

Post Reply
mdbrna
Posts: 1
Joined: Sat Nov 23, 2019 12:18 am

sqlite query error

Post by mdbrna » Sat Nov 23, 2019 12:30 am

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:

Post Reply

Return to “Databases”