Updating values of my sqlite Database did not works

Solar2D Lua Language
#1

Dear Forum Member,

Here is a Screenshot of my Database:

http://1mage.in/show/08_12_2013-915389-Unterschrift.PNG

I can read from the Database but when i print the values out, it will be showed that value 5 is not true and therefore anything is wrong. 

    q = [[UPDATE datenbank SET werte='true' WHERE id=5;]]     db:exec( q )  

Thanks before. 

Matthias

#2

There seems to be no ‘id’ column in the screenshot provided.

What type of column is ‘werte’?

#3

Sorry forgot, but the table name is “freigeshaltet”, but you are trying to update “datenbank”, need to replace that with “freigeshaltet”

#4

Hey, 

I edited so : 

q = [[UPDATE freigeschaltet SET werte='true' WHERE id=5;]] db:exec( q )  

but its didnt work.

Did i have to custom a column with the name ‘id’ ?

Thanks 

Matthias

Thanks its work when i custom a field. 

#5

Try with ’ ’ surrounding where id=5 such that it looks like the following : 

q = [[UPDATE freigeschaltet SET werte=‘true’ WHERE id=‘5’;]]

Hope that will help.

#6

There seems to be no ‘id’ column in the screenshot provided.

What type of column is ‘werte’?

#7

Sorry forgot, but the table name is “freigeshaltet”, but you are trying to update “datenbank”, need to replace that with “freigeshaltet”

#8

Hey, 

I edited so : 

q = [[UPDATE freigeschaltet SET werte='true' WHERE id=5;]] db:exec( q )  

but its didnt work.

Did i have to custom a column with the name ‘id’ ?

Thanks 

Matthias

Thanks its work when i custom a field. 

#9

Try with ’ ’ surrounding where id=5 such that it looks like the following : 

q = [[UPDATE freigeschaltet SET werte=‘true’ WHERE id=‘5’;]]

Hope that will help.