SQLite Update Statement Help

Solar2D General Questions/Discussion
#1

Hello:

Can anyone help with this statement:

[lua]local playID = 2
local note = “testing my notes”
local sql =“UPDATE playNotes SET Notes=” … note … " WHERE PlayID= "… playID
db:exec(sql)[/lua]

I have tried everything I know how…any help would be appreciated.

Thanks [import]uid: 66859 topic_id: 17431 reply_id: 317431[/import]

#2

When working with strings within a SQL statement you need to use single quotes around them, like this:

[lua]local sql =“UPDATE playNotes SET Notes=’” … note … "’ WHERE PlayID= "… playID[/lua]
Raúl Beltrán
MIU Games [import]uid: 44101 topic_id: 17431 reply_id: 66028[/import]

#3

Ah I see… Thank you! [import]uid: 66859 topic_id: 17431 reply_id: 66081[/import]