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 = …
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?
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 …
Best Practice for Database Design for use in XoJo
Dec 2, 2021 · I’m still deep in the process of coming up to speed in XoJo, loving the tool though. My question for Databases is, which of the following would be the best approach to design a database …
A Thread on Building the What The Fly? App - Xojo Programming Forum
Feb 8, 2024 · The other tools (apps) I think I will use are DBKit, SQLite, SQLiteStudio, OmniGraffle, BBEdit, Perl, and perhaps some XOJO plugins. Next, a couple of conventions I will use. Questions to …
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 …
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. …
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 …
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 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 …