I have been having problems reading and writing to an sqlite database in Xojo. This has been an intermittent problem on and off for a few months. For no apparent reason, I get an error message, “No such table: table name” when I try to create a recordset. I can connect to the database without issue but cannot create a recordset. I have looked through countless pages on the forum for this issue but could not find any posts specific to this problem. Don’t understand how this code can work then not work without changing the code. db is defined as a global. Below is the code I am using: Thanks in advance for any help.
db = new SQLiteDatabase
dim rs as RecordSet
dim wInitial as String
db.DatabaseFile=GetFolderItem(gDBSourceString)
if db.Connect then
rs = db.SQLSelect(“Select * from ClientMaster order by cm_MainLastName, cm_MainFirstName”)
rs.MoveFirst
popClient.AddRow "N/A"
do until rs.EOF
wInitial = mid(rs.Field("cm_MainFirstName").StringValue,1,1)
popClient.AddRow wInitial + ". " + rs.Field("cm_MainLastName").StringValue
rs.MoveNext
loop
popClient.ListIndex = 1
popService.ListIndex = 1
rs.Close
end if