In SQLite field If I use default value as for example - DateTime('now') I need to put them in surrounding parentheses like: (DateTime('now')). After inserting, program showing value without them, so on every edit I need to surround value again with ...
are you planning to upgrade the SQLite library in Valentina Studio to one of the latest available versions? If so, when? Valentina Studio now uses the SQLite library version 3.31.1, which does not allow the use of SQL UPDATE-FROM syntax. This...
I’m migrating my existing project in Xojo (2019 3.2) and my existing SQLite database (1 table, and 1 virtual table created with FTS5 to use full search) and some triggers to make stay in sync the 2 tables, in Valentina SQLiteServer.
I’m now on my MB...
I tried Valentina Studio Free (both on Mac and Linux), with an existing sqlite database but I have some problems with missing fields.
For example :
What is created and OK in other DB Tools :