Android Question Why do I get No such table?

Probably a stupid question, but I am just starting with Basic4Android. I don't understand why I get a "no such table" from the second Query. Surely the first one would have created it.


Sub btnArchersD_Click
'Label1.Text = "Archers diary"
Dim cursor1 As Cursor
SQL1.BeginTransaction
Try
SQL1.ExecNonQuery("CREATE TABLE IF NOT EXISTS archers(archerID Integer Primary Key, FName Text, LName Text, BowType Text)")
Catch
Log(LastException.Message)
End Try
SQL1.EndTransaction
' check if any entries in table
SQL1.BeginTransaction
Try
cursor1 = SQL1.ExecQuery("SELECT * FROM archers")
Catch
Log(LastException.Message)
End Try
SQL1.EndTransaction