working with date in sqlite in shopping list exercise

netchicken

netchicken

Active Member
Licensed User
Longtime User
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
B4X: 
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
 
Last edited:
netchicken

netchicken

Active Member
Licensed User
Longtime User
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.
 
You must log in or register to reply here.