tsteward Well-Known Member Licensed User Longtime User Jul 13, 2024 #1 Firebase reports no such table: Settings (code 1 SQLITE_ERROR[1]): , while compiling: SELECT * FROM Settings WHERE Description = 'Version' This is definatly there. And only reports this error sometimes. Have I formatted my code poorly? Or what causes this B4X: Copy Dim rs As ResultSet = Main.sql1.ExecQuery($"SELECT * FROM Settings WHERE Description = 'Version'"$)
Firebase reports no such table: Settings (code 1 SQLITE_ERROR[1]): , while compiling: SELECT * FROM Settings WHERE Description = 'Version' This is definatly there. And only reports this error sometimes. Have I formatted my code poorly? Or what causes this B4X: Copy Dim rs As ResultSet = Main.sql1.ExecQuery($"SELECT * FROM Settings WHERE Description = 'Version'"$)
asales Expert Licensed User Longtime User Jul 13, 2024 #2 This is an activity project or b4xpages project? If is an activity project, maybe is better to initialize the SQL in the Starter service. If is a b4xpages project, use the b4xmainpage. Upvote 0
This is an activity project or b4xpages project? If is an activity project, maybe is better to initialize the SQL in the Starter service. If is a b4xpages project, use the b4xmainpage.
tsteward Well-Known Member Licensed User Longtime User Jul 14, 2024 #3 This is a b4xpages project and I do initialize the database in the b4xmainpage. Seems to be fine in over 3000 installs but occasional crash on less than a few devices. Probably not something to be too concerned about I guess Upvote 0
This is a b4xpages project and I do initialize the database in the b4xmainpage. Seems to be fine in over 3000 installs but occasional crash on less than a few devices. Probably not something to be too concerned about I guess
