lundi 15 juin 2015

using varibel in sqlite query corona

i want to update row table in sqlite database (Corona SDK) using variabel, but i have stuck to call variabel in query

value = true
i = 1

local q = [[UPDATE keadaan SET status=']].. 'value' ..[[' WHERE id=']].. 'i' ..[[';]]
db:exec( q )

anyone can help me ?

Aucun commentaire:

Enregistrer un commentaire