Windows Alternative to Base - Windows - Xojo Programming Forum
Jun 15, 2018 · I use Base.app on macOS as a SQLite browser. What is the best product like this for Windows?
SQLite: delete a Column ? - Databases - Xojo Programming Forum
Dec 7, 2016 · Where I have needed this I have created the new column (ALTER TABLE ADD columnName TEXT), copied the data from the old column (UPDATE tableName SET newColumn = …
SQLite 1000 row limit?! - General - Xojo Programming Forum
May 18, 2016 · Hi All, I’m writing to a SQLite database, and after 1000 rows it isn’t taking any more inserts. There is no error, the insert statement completes successfully but the row just gets …
Is there a max character length of a SQLite field (TEXT/VARCHAR)?
Oct 10, 2017 · Hi. Quick question. Is there a limit to the number of characters a field in SQLite can accept? I’m currently working on a study guide with various modules/chapters. I’ve been sub …
Storing currency values in SQLite database - Databases - Xojo ...
Aug 1, 2017 · What is the currently recommended way to store currency values in s SQLite database? I see the following in the Xojo docs: [quote] Use the REAL data type to store currency values in …
SQLite INNER JOIN Issue - Databases - Xojo Programming Forum
Jun 4, 2019 · My Web App is coming along pretty well. But I’ve had trouble regarding an INNER JOIN. I’ve checked the SQLite Statement in SQLiteStudio and it returns perfectly what I’m looking for with …
ORDER BY not working - Databases - Xojo Programming Forum
Jun 11, 2013 · I have a database where ORDER is very important. In 3 different database browsers ORDER BY works fine. Cut and paste the SQL to RB 2012 r2 and the order of the records is wrong. …
Unable to drop a Column in SQLite - Xojo Programming Forum
Jul 2, 2022 · SqLite does not support dropping a column. You have to create a copy of the table (along with its data), drop the original table, recreate the original without the column, and copy the data back …
SQLite database password - Databases - Xojo Programming Forum
Jun 26, 2024 · When we use the password, does that actually result in a truly encrypted database? Or are we just relying on programs not peeking past the gate, so to speak, when a password is incorrect?
SQLite Duplicate Record - Databases - Xojo Programming Forum
Sep 12, 2017 · I need to build a temporary table from a complex selection of records from a SQLite table. Is there a way to duplicate the record from one table into another table without manually …