sqlite update error on windows.

Getting Started Newbie Questions
#1

Hi…I’m trying to update some datas in a specific rowid of my database. I created the code and tested it on corona simulator of my iMac.

It works fine but when i try to test in my second pc (windows ) the code doesn’t work.

Nothing error.

 Why that? There is difference of syntax between 2 OS ?

I allegate my code :

local q = "UPDATE Datas SET import = '".. xxx .."', sc1 = '" .. score1.text .."', sc2 = '" .. score2.text .."', sc3 = '" .. score3.text .. "' WHERE idrecord = '" .. ids.. "'" db:exec( q )

Thanks for your helps.

#2

I would suggest that the likely problem is in how the database is getting created. Perhaps your first PC is depending on an database that already exists in your system.DocumentsDirectory. The version running on the second PC isn’t creating the database correctly. Maybe a bug found its way into your creation code and since you already had a good database on PC1, PC2 is failing.

#3

I would suggest that the likely problem is in how the database is getting created. Perhaps your first PC is depending on an database that already exists in your system.DocumentsDirectory. The version running on the second PC isn’t creating the database correctly. Maybe a bug found its way into your creation code and since you already had a good database on PC1, PC2 is failing.