Sqlite and clock storage options

MIT App Inventor Help
7

I remembered the issue with SimpleSqlite you can read about it here:

Store your millis value as a string (so set the table column to TEXT)

e.g.

CREATE TABLE IF NOT EXISTS "millisTest" ("id" INTEGER NOT NULL, "millis" TEXT, PRIMARY KEY("id"))

INSERT INTO millisTest(millis) VALUES("1729784461149")

SELECT * FROM millisTest

output: [[1, "1729784461149"]]

Problem solved, AI2 will handle the string value as a number.

[edit - I have now added this quirk to my guide: Working with SQLite]

1 Like