This SQL worked using DatabaseQuery(), using SQLite db on Windows 10 Pro x64.DatabaseQuery() wrote:Only queries which doesn't change the database records are accepted ('SELECT' like queries). To performs database modification, use DatabaseUpdate().
Code: Select all
q$ = "UPDATE `MyTable` SET `X`=" + Str(#PI)
q$ + " WHERE `r(id)`=" + Str(my_id) + #SEMI$