SQLite INNER JOIN Issue - Databases - Xojo Programming Forum
2019年6月4日 · 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 …
How to store a hashed password in an SQLite DB?
2014年4月3日 · I am trying this … To store the password: Dim Hash As String = Crypto.Hash(k, Crypto.Algorithm.SHA512) rs.Edit rs.Field(“UserPassword”).StringValue = Hash rs.Update To retrieve the password: // User enters name in textfield1 and password in textfield2 Dim Hash1 As String = Crypto.Hash(textfield2.text, Crypto.Algorithm.SHA512) Dim rs As RecordSet = …
Is there a max character length of a SQLite field (TEXT/VARCHAR)?
2017年10月10日 · 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 …
SQLite 1000 row limit?! - General - Xojo Programming Forum
2016年5月18日 · 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. …
ORDER BY not working - Databases - Xojo Programming Forum
2013年6月11日 · 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. It doesn’t make any sense to me. Anyone have a clue what could be happening? The code is pretty simple SELECT * FROM [FF_NotEnoughCourses] ORDER BY …
SQLite Duplicate Record - Databases - Xojo Programming Forum
2017年9月12日 · 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?
Deleting All Records In A SqLite Table At Once
2013年9月13日 · Hello, I am trying to delete all the records in a SQLite Table with one click of a button. The name of the database is Roster. The table name is Report1. The code I am trying to use is: [code] Roster= new RealSQLDatabase Roster.DatabaseFile = GetFolderItem(“Roster.rsd”) Dim sqlDelete as String sqlDelete=“SELECT * FROM Report1” …
Storing currency values in SQLite database - Databases - Xojo ...
2017年8月1日 · 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 conjunction with DatabaseRecord.CurrencyColumn and DatabaseField.CurrencyValue.[/quote] But I also see others in the forum saying to use …
A Thread on Building the What The Fly? App
2024年2月8日 · Dear All, After some discussion on the forum, I have decided to do a ‘build’ thread. In this thread, you will follow along, and participate, with the creation of an application to help Fly Tyers keep organized. As we go along, you will probably learn more than you wanted to know about Fly Tying. I understand that is part of building a good app. This may also totally …
SQLite: what happens if two (or more) people want to access to …
2018年7月5日 · If user “A” reads record 43, and user “B” reads record 43, the user “A” updates it, followed by user “B” updating it… whatever user “A” did would be gone and over-written by user “B”… assuming there was no active record/table/database locks, and that the transactions did not occur at the same or overlapping times.