Jun 15, 2018 · I use Base.app on macOS as a SQLite browser. What is the best product like this for Windows?

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 …

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 …

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 …

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 …

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 …

Mar 3, 2018 · I have datetime as string like “02/03/2018 21:24”. I’m trying to store it to SQLite database where I have created datetime field. This is how I try to insert date:

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 …

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 …

Jun 20, 2025 · On Web can the TabIndex of a WebTextField be specified at design time without adding code? Just getting back into Xojo and haven’t really used Web 2.0 so hopefully these …