Android Question Sqlite saveing

TomDuncan

Active Member
Licensed User
Longtime User
Hi All,
I have a program which does this
B4X: 
SQL.ExecNonQuery("UPDATE daytimes SET patient = '" & DataToSave & "', modified = 1 " & Where)
Where DataToSave is a String.
All is fine till today when testing I put in
Tom's birthday.
What has happened is the ' for Tom has corrupted the data being saved.
How can I fix this error.

I did think of Encoding Base 64 but then all previous data would not work.

Tom

oops Saving, sorry about that
 
Sort by date Sort by votes
S

sorex

Expert
Licensed User
Longtime User
you need to escape your DataToSave string.

B4X: 
SQL.ExecNonQuery("UPDATE daytimes SET patient = '" & DataToSave.replace("'","\'") & "', modified = 1 " & Where)
 
Upvote 0
M

Mahares

Expert
Licensed User
Longtime User
If you do not want to worry about escaping, you are better off using a parameterised query:
B4X: 
SQL.ExecNonQuery2("UPDATE daytimes SET patient = ?, modified = ? " & Where), _
        Array As Object(DataToSave, 1))
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Article
Android Code Snippet Send and Save Data into SQLite on Another Device (using UDP)
Replies
2
Views
987
Erel
  • Question
Other Exporting Sqlite data
Replies
2
Views
979
LucaMs
  • Locked
  • Article
Android Code Snippet SaveAs - Let the user select a target folder + list of other related methods
Replies
16
Views
23K
Erel
  • Question
Android Question Problem saving data quickly in SqLite
Replies
5
Views
1K
Erel
  • Article
Android Code Snippet Save and load CSBuilders
Replies
5
Views
4K
jmon
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…