working with date in sqlite in shopping list exercise

[netchicken]

Hi,
I am trying to have the shopping list from this exercise http://www.b4x.com/forum/basic4andr...ns/9010-shopping-list-database.html#post52109 update by a short click on the item - eventually


I can generate a number with this but not update the field with it

Dim today As Long      ' todays date
today = DateTime.Now

Msgbox("Today is: " & today, "") 
'update new date
SQL1.ExecNonQuery("UPDATE shopping SET PurchaseDate Values('"today "')")

Thanks for your help

 

[Erel]

What is the error message?

 

[netchicken]

Whoops!

I have just realized, after a day of fighting this thing, that I am not looking at the same db in sqlitemanager as is being seen in the phone becuase changes to entries on the phone are not being updated in the manager.

So the coding is being updated but not the db structure, therefore the changes I make arn't working. I can work it out from here.

databases are the bane of my life. ......

Thanks again.