Android Question DBUtils: How to create a field that allows null values?

[Frank Cazabon]

Hi,

Do I have to do anything special to create a table in an SQLite database with a field that accepts null values?

Here's my code to create the table and I want to allow a null value to be put in srt_date:

    Dim m As Map
    m.Initialize
    m.Put("srt_name", DBUtils.DB_TEXT)
    m.Put("srt_date", DBUtils.DB_TEXT)
    DBUtils.CreateTable(SQLite, "SelectedRoute", m, "")

 

[LucaMs]

You do not need anything else.

Hopefully, that function (CreateTable) should be modified in such a way that it allows you to add NOT NULL, CHECK, UNIQUE, PRIMARY KEY and FOREIGN KEY constraints

 

[Beja]

You can convert the null value to empty string ""

Check this thread:
http://www.b4x.com/android/forum/threads/display-of-sqlite-null-values.34087/#post-199594

 

[Frank Cazabon]

Thanks Beja and LucasM