|
- Windows Alternative to Base - Windows - Xojo Programming Forum
I use Base app on macOS as a SQLite browser What is the best product like this for Windows?
- ¿Hay limite de parametros en consulta SQL (SQLite)?
Hola: Os comento Tengo una base de datos con una tabla -en realidad mas de una tabla, pero solo se hace consulta a una- , de esta necesito extraer los totales de ciertos campos que cumplan unas condiciones y que se presentan en un ListBox en otra ventana … bueno, pues el primer metodo con las sentencias SQL funcionan de maravilla (presentar el total de las cantidades almacenadas en sendos
- SQLite 1000 row limit?! - General - Xojo Programming Forum
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 swallowed I also tried from a tool called SQLIte Studio and it’s the same If i delete a row, I can then insert one but no more There’s rowid as primary key and a couple other columns Anybody seen
- Question about design - General - Xojo Programming Forum
The project main window have a ListBox and some buttons When the user choose an entry in the ListBox, a second window appears and show data Is it possible to not swap from one window to the other (excepted if the user specifically want that by a click in the data window, of course) ? I tried floating window (NO), global window (it stays above all windows, of course, so NO too) Ideas ?
- SQLite Duplicate Record - Databases - Xojo Programming Forum
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 copying each individual field? thanks,
- Is there a max character length of a SQLite field (TEXT VARCHAR)?
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-sectioning each topic, but some are still quite lengthy I don’t want to run into an issue where some of the text is not saving because I’ve gone past the limit At least if I know, I can be sure to stay below
- SQLite database password - Databases - Xojo Programming Forum
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 INNER JOIN Issue - Databases - Xojo Programming Forum
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 no errors, with both Patient Doctor data, but it doesn’t work in my Xojo Program I’ve ensured that all column names are different (even the ID columns) as I heard that can produce issues
|
|
|