I have been working on a DB app and I am progressing but I am a bit stumped with the update record.
I am using jsql and the insert,delete,select are fine. This is this is the query I am using:
The data table structure is in the attached screen capture.
The error I get is
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "when": syntax error)
I know this is going to be obvious but I have looked at this for hours and tried heaps of suggestions from the forum but to no avail.....
I am using jsql and the insert,delete,select are fine. This is this is the query I am using:
B4X:
sql1.BeginTransaction
Try
sql1.ExecNonQuery2("UPDATE myItems SET item=?, WhereP=?, when=?, cost=?, warranty=?, itemPic=?, recPic=? where item=?", Array As Object(strItem,strWhere,lngTicks,strCost,strWarranty,buffer1,buffer2,strItem))
Catch
Log(LastException.Message)
End TryThe data table structure is in the attached screen capture.
The error I get is
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "when": syntax error)
I know this is going to be obvious but I have looked at this for hours and tried heaps of suggestions from the forum but to no avail.....