Android Question [SOLVED] Sqlite vs B4X Null-Value

Knoppi

Active Member
Licensed User
Longtime User
i have a sqlite database specified by a company
I cannot change this database because other programs also use it
unfortunately one field was defined as follows
B4X:
CREATE TABLE "test" (
    "field1"    TEXT
);
so I have the problem that there can be five different values in the field
  • NULL (the Sqlite-Null value)
  • "null" (a String with value "null")
  • "NULL" (a String with value "NULL")
  • "" (a empty String)
  • "Some Text" (a String)
the values "null" and "NULL" are used by other programs

unfortunately b4x-String returns "null" at Sqlite-NULL.
How can I distinguish Sqlite-NULL from "null"-String?
 
Top