Android Question DBUtils.TableExists throwing 'java.lang.ClassCastException'

A

Amalgamated Sugar

Member
Licensed User
Good day!

I'm trying to create a conditional service on if a table exists. However, when I test for the existence of said table:

B4X: 
If (DBUtils.TableExists(Starter.localSQL, "Contracts")) = False Then
        StartService(Contracts)
    
End If

I get the following error message:

B4X: 
java.lang.ClassCastException: java.lang.Object[] cannot be cast to java.lang.String[]
     at b4a.example.dbutils._tableexists(dbutils.java:1148)

I'm using DBUtils version 2.05. Has any one else run into an issue like this?

Thank you in advance!
Michael
 
Sort by date Sort by votes
A

Amalgamated Sugar

Member
Licensed User
I think I found the issue... In DBUtils v2.05, the Sub 'TableExists' reads:

B4X: 
'Tests whether the given table exists
Public Sub TableExists(SQL As SQL, TableName As String) As Boolean
 Dim count As Int = SQL.ExecQuerySingleResult2("SELECT count(name) FROM sqlite_master WHERE type='table' AND name=? COLLATE NOCASE", Array(TableName))
 Return count > 0
End Sub


When I changed 'Array(TableName)' to 'Array As String(TableName)' the sub works...
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
Android Question I can't run the WobbleMenu and B4XPages example
Replies
0
Views
793
vascofire
  • Question
Android Question java.lang.ClassNotFoundException: Invalid name: b4a.example.class b4a.example.main
Replies
2
Views
2K
Erel
I
  • Question
Android Question Runtime error
Replies
2
Views
1K
AnandGupta
I
  • Question
Android Question java.lang.RuntimeException: Method: setValue not matched.
Replies
2
Views
1K
Erel
R
  • Question
Android Question Runmethod not matched
Replies
1
Views
1K
rosippc64a
R
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…