Hi, I made my initial DB though sqlite studio which allowed me to choose DateTime for a few fields
Now I want to write the code in my application so that if the file is not there it can create it but according to DButils 2 there are only a few field types avail
So there is no DATETIME
I have used text instead but I do not know how that would affect any conversions down the line ie SQL date to ticks
Advise would be appreciated, thank you
Fields in SQLite Studio:
CREATE TABLE chat (
logcount INTEGER UNIQUE
PRIMARY KEY AUTOINCREMENT
NOT NULL,
topic STRING,
servertime DATETIME,
message STRING,
senttime DATETIME,
deliveredtime DATETIME,
viewedtime DATETIME,
fromuser STRING,
messageno STRING,
messagedts REAL UNIQUE,
reference STRING,
image STRING,
fromusername STRING,
thumbnailfilename STRING
);Now I want to write the code in my application so that if the file is not there it can create it but according to DButils 2 there are only a few field types avail
So there is no DATETIME
I have used text instead but I do not know how that would affect any conversions down the line ie SQL date to ticks
B4X:
Dim o As Map
o.Initialize
o.Put("logcount", DBUtils.DB_INTEGER)
o.Put("servertime", DBUtils.DB_TEXT)
o.Put("message", DBUtils.DB_TEXT)
o.Put("senttime", DBUtils.DB_TEXT)
o.Put("deliveredtime", DBUtils.DB_TEXT)
o.Put("viewedtime", DBUtils.DB_TEXT)
o.Put("fromuser", DBUtils.DB_TEXT)
o.Put("messageno", DBUtils.DB_TEXT)
o.Put("messagedts", DBUtils.DB_REAL)
o.Put("reference", DBUtils.DB_TEXT)
o.Put("image", DBUtils.DB_TEXT)
o.Put("fromusername", DBUtils.DB_TEXT)
o.Put("thumbnailfilename", DBUtils.DB_TEXT)Advise would be appreciated, thank you