Hello guys…
I am using SQLite for my game project in Corona.
and I am storing a .lrc file on it so i create a table that has a blob field.
so this is what i have done…
[lua]local tablesetup = [[CREATE TABLE IF NOT EXISTS files (id INTEGER PRIMARY KEY, file BLOB);]]
db:exec( tablesetup )[/lua]
when i try to insert a data on my table using this code…
[lua]local tablefill =[[INSERT INTO files VALUES (NULL, (@asd.lrc));]]
db:exec( tablefill )[/lua]
and when i view my SQLite database, it is completely empty…
is my query correct?
i look at to the command prompt but there is no error displayed on it.
I’m new with Corona, and I am not too familiar with it. But I am willing to learn it.
can anyone can help me about my situation?
thanks in advance … [import]uid: 142834 topic_id: 26131 reply_id: 326131[/import]