macOS 11.4, Xojo 2021.2.1, Desktop App.
I have a sqlite database with a table name “Times”. It has an integer column named fkTask. There is currently 1 record in the table and the value of fkTask is 1.
If I execute the following code I get the message that says “No Task Found…”, If I just say “SELECT * FROM Times” then I get the 1 record with the fkTask value of 1.
The SQL SELECT statement looks correct in the debugger. If I type the select statement in an app called BASE, it executes properly and retrieves the record.
What the hell am I missing???
Shared Function RowSetTask(iTask As Integer) As RowSet var rs As RowSet var sSQL As String var sMsg As String sSQL = "SELECT * FROM Times WHERE fkTask = " + iTask.ToString try rs = dbSQL.SelectSQL(sSQL) if rs.RowCount = 0 then MessageBox("No Tasks Found for Task " + iTask.ToString) end if catch Err as DatabaseException sMsg = "Database error occured retrieving Times " + Err.Message clsSystemLog.WriteLog(CurrentMethodName, sMsg) end try Return rs End Function