https://www.b4x.com/android/forum/threads/sqlite-insert-or-replace-doesnt-work-with-empty-string-in-key-field.98871/
SQLite INSERT OR REPLACE doesn't work with empty string in key field | B4X Programming Forum
I am trying to use INSERT OR REPLACE but one of the key fields contains an empty space. For example: LastName = 'Jones' FirstName = 'Mary' MiddleName = ''...
sqlite insertwork withempty stringreplacekey