Android Question File.Exist(......) always False

JakeBullet70 said:

MyTable is not a file. It is contained inside the database.

B4X:

Sub TableExists(oSQL As SQL,TableName As String) As Boolean'ignore
    Dim Ret As String
    Ret = oSQL.ExecQuerySingleResult("SELECT name FROM sqlite_master WHERE type='table' AND name='" & TableName & "'")
    Try
        If Ret = TableName Then
            Return True          
        Else
            Return False
        End If
    Catch
        Return False
    End Try
End Sub

Click to expand...

casher2 said:

I've tried every possible change to SQL Initialize and File.Exists I can think of to no avail. What am I missing? Thanks!!

Click to expand...

Sub Process_Globals
    Dim SQL1 as SQL
End Sub

Sub Globals
  Dim qry as String
End Sub


Sub Activity_Create(FirstTime AsBoolean)
  If FirstTime Then
       SQL1.Initialize(File.DirInternal,"Test.db",True)
  End If
  qry="Create Table if not exists MyTable (MyField Integer)"
  SQL1.ExecNonQuery(qry)
End sub