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
so I have the problem that there can be five different values in the field
unfortunately b4x-String returns "null" at Sqlite-NULL.
How can I distinguish Sqlite-NULL from "null"-String?
I cannot change this database because other programs also use it
unfortunately one field was defined as follows
B4X:
CREATE TABLE "test" (
"field1" TEXT
);- NULL (the Sqlite-Null value)
- "null" (a String with value "null")
- "NULL" (a String with value "NULL")
- "" (a empty String)
- "Some Text" (a String)
unfortunately b4x-String returns "null" at Sqlite-NULL.
How can I distinguish Sqlite-NULL from "null"-String?