Android Question SQLite check if table exists

D

Declan

Well-Known Member
Licensed User
Longtime User
In my Starter, I am checking for a SQLite Database.
If it does not exist, I create the Database (leadguru.db) with "CreateDB"
I then check for a table (user) with "readUser"
If it does nor exist, I must create it.
However I get the following Error:
B4X: 
Logger connected to:  Xiaomi MI 4W
--------- beginning of main
Copying updated assets files (8)
*** Service (starter) Create ***
GOT leadguru.db
** Service (starter) Start **
** Activity (main) Create, isFirst = true **
** Activity (main) Resume **
*** Service (firebasemessaging) Create ***
** Service (firebasemessaging) Start **
** Activity (main) Pause, UserClosed = true **
** Service (starter) Destroy (ignored)**
*** Service (starter) Create ***
GOT leadguru.db
Error occurred on line: 43 (Starter)
java.lang.RuntimeException: Object should first be initialized.
    at anywheresoftware.b4a.sql.SQL.checkNull(SQL.java:55)
    at anywheresoftware.b4a.sql.SQL.ExecQuerySingleResult2(SQL.java:244)
    at anywheresoftware.b4a.sql.SQL.ExecQuerySingleResult(SQL.java:234)
    at com.rob.leadguru.starter._readusers(starter.java:196)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:348)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:176)
    at com.rob.leadguru.starter.onCreate(starter.java:56)
    at android.app.ActivityThread.handleCreateService(ActivityThread.java:2944)
    at android.app.ActivityThread.access$2000(ActivityThread.java:156)
    at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1492)
    at android.os.Handler.dispatchMessage(Handler.java:102)
    at android.os.Looper.loop(Looper.java:157)
    at android.app.ActivityThread.main(ActivityThread.java:5653)
    at java.lang.reflect.Method.invoke(Native Method)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:746)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:636)
** Service (starter) Start **
*** Service (starter) Create ***
GOT leadguru.db
Error occurred on line: 43 (Starter)
java.lang.RuntimeException: Object should first be initialized.
    at anywheresoftware.b4a.sql.SQL.checkNull(SQL.java:55)
    at anywheresoftware.b4a.sql.SQL.ExecQuerySingleResult2(SQL.java:244)
    at anywheresoftware.b4a.sql.SQL.ExecQuerySingleResult(SQL.java:234)
    at com.rob.leadguru.starter._readusers(starter.java:196)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:732)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:348)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:176)
    at com.rob.leadguru.starter.onCreate(starter.java:56)
    at android.app.ActivityThread.handleCreateService(ActivityThread.java:2944)
    at android.app.ActivityThread.access$2000(ActivityThread.java:156)
    at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1492)
    at android.os.Handler.dispatchMessage(Handler.java:102)
    at android.os.Looper.loop(Looper.java:157)
    at android.app.ActivityThread.main(ActivityThread.java:5653)
    at java.lang.reflect.Method.invoke(Native Method)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:746)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:636)
** Service (starter) Start **
*** Service (starter) Create ***
GOT leadguru.db
Error occurred on line: 45 (Starter)
java.lang.RuntimeException: Object should first be initialized.
    at anywheresoftware.b4a.sql.SQL.checkNull(SQL.java:55)
    at anywheresoftware.b4a.sql.SQL.ExecNonQuery(SQL.java:73)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.shell.Shell.runVoidMethod(Shell.java:777)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:354)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:176)
    at com.rob.leadguru.starter.onCreate(starter.java:56)
    at android.app.ActivityThread.handleCreateService(ActivityThread.java:2944)
    at android.app.ActivityThread.access$2000(ActivityThread.java:156)
    at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1492)
    at android.os.Handler.dispatchMessage(Handler.java:102)
    at android.os.Looper.loop(Looper.java:157)
    at android.app.ActivityThread.main(ActivityThread.java:5653)
    at java.lang.reflect.Method.invoke(Native Method)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:746)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:636)
*** Service (starter) Create ***
GOT leadguru.db
Error occurred on line: 46 (Starter)
java.lang.RuntimeException: Object should first be initialized.
    at anywheresoftware.b4a.sql.SQL.checkNull(SQL.java:55)
    at anywheresoftware.b4a.sql.SQL.ExecNonQuery(SQL.java:73)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.shell.Shell.runVoidMethod(Shell.java:777)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:354)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:176)
    at com.rob.leadguru.starter.onCreate(starter.java:56)
    at android.app.ActivityThread.handleCreateService(ActivityThread.java:2944)
    at android.app.ActivityThread.access$2000(ActivityThread.java:156)
    at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1492)
    at android.os.Handler.dispatchMessage(Handler.java:102)
    at android.os.Looper.loop(Looper.java:157)
    at android.app.ActivityThread.main(ActivityThread.java:5653)
    at java.lang.reflect.Method.invoke(Native Method)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:746)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:636)
*** Service (starter) Create ***
GOT leadguru.db
Error occurred on line: 45 (Starter)
java.lang.RuntimeException: Object should first be initialized.
    at anywheresoftware.b4a.sql.SQL.checkNull(SQL.java:55)
    at anywheresoftware.b4a.sql.SQL.ExecNonQuery(SQL.java:73)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.shell.Shell.runVoidMethod(Shell.java:777)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:354)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:255)
    at java.lang.reflect.Method.invoke(Native Method)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:144)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:176)
    at com.rob.leadguru.starter.onCreate(starter.java:56)
    at android.app.ActivityThread.handleCreateService(ActivityThread.java:2944)
    at android.app.ActivityThread.access$2000(ActivityThread.java:156)
    at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1492)
    at android.os.Handler.dispatchMessage(Handler.java:102)
    at android.os.Looper.loop(Looper.java:157)
    at android.app.ActivityThread.main(ActivityThread.java:5653)
    at java.lang.reflect.Method.invoke(Native Method)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:746)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:636)

My Code in Starter:
B4X: 
#Region  Service Attributes
    #StartAtBoot: False
    #ExcludeFromLibrary: True
#End Region

Sub Process_Globals
    Public csu As CallSubUtils
    Type Message (Address As String, Body As String)
    
    Dim DB As SQL
    Dim DBFileDir As String = File.DirInternal
    Dim DBFileName As String = "leadguru.db"

End Sub

Sub Service_Create
    ' Delay Sub
    csu.Initialize
    
    ' Setup SQL
    If File.Exists(DBFileDir, DBFileName) Then
        LogColor("GOT leadguru.db", Colors.Magenta)
        readUser
    Else
        LogColor("NO leadguru.db", Colors.Magenta)
        CreateDB
    End If
    
    'Firebase
    CallSubDelayed(FirebaseMessaging, "SubscribeToTopics")

End Sub

Sub CreateDB
    LogColor("Create leadguru.db", Colors.Magenta)
    DB.Initialize(DBFileDir, DBFileName, True)
    
    readUser
End Sub

Sub readUser
    Dim txt As String
    txt="CREATE TABLE IF NOT EXISTS  user (mobileno TEXT)"
    DB.ExecNonQuery(txt) '<----------------------------------Get ERROR HERE

    Dim ret As Int
    ret = DB.ExecQuerySingleResult("SELECT count(*) FROM user")

    If ret <= 0 Then
        LogColor("Table Exists BUT is Empty", Colors.Magenta)
        'Now load Input Dialog in Main
    Else
        LogColor("Table Has: "&ret, Colors.Magenta)
        'If records are = 1, then just go to Main
        
    End If
End Sub



Sub Service_Start (StartingIntent As Intent)
    Service.StopAutomaticForeground 'Starter service can start in the foreground state in some edge cases.
End Sub

Sub Service_TaskRemoved
    'This event will be raised when the user removes the app from the recent apps list.
End Sub

'Return true to allow the OS default exceptions handler to handle the uncaught exception.
Sub Application_Error (Error As Exception, StackTrace As String) As Boolean
    Return True
End Sub

Sub Service_Destroy

End Sub
 
Sort by date Sort by votes
PdeG

PdeG

Member
Licensed User
Longtime User
B4X: 
qry = $"CREATE TABLE IF NOT EXISTS <table>
        (<id> INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
        <column> TEXT)"$
    vSql.ExecNonQuery(qry)
 
Upvote 0
D

Declan

Well-Known Member
Licensed User
Longtime User
Many Thanks
Added:
B4X: 
    Dim txt As String
    txt="CREATE TABLE IF NOT EXISTS  user (mobileno TEXT)"
    DB.Initialize(DBFileDir, DBFileName, True)
    DB.ExecNonQuery(txt)
 
Upvote 0
Erel

Erel

B4X founder
Staff member
Licensed User
Longtime User
You can also use DBUtils.TableExists.

[B4X] DBUtils 2

DBUtils is a b4xlib with useful utilities related to the SQL library. It is designed to work with SQLite databases. There have been three versions of DBUtils, one for each platform (except of B4R). DBUtils v2.0 merges the three modules to a single module that is compatible with B4A, B4i and...
www.b4x.com www.b4x.com
 
Upvote 0
You must log in or register to reply here.

Similar Threads

A
  • Question
Android Question SQLite Check if row exists in table
Replies
1
Views
1K
Erel
Erel
Alexander Stolte
  • Article
Android Code Snippet SQLite - check table exists
Replies
2
Views
3K
KMatle
KMatle
Erel
  • Locked
  • Article
B4A Library [B4X] B4XTable - Cross platform, sortable, searchable, customizable table
2
Replies
28
Views
61K
Erel
Erel
Star-Dust
  • Article
B4J Library [B4X] [XUI] SD FlexGrid (Table)
10 11 12
Replies
220
Views
54K
Star-Dust
Star-Dust
M
  • Article
B4A Library [Class] Flexible Table
64 65 66
Replies
1K
Views
283K
Sergey_New
S
Top