Android Question Why do I get No such table?

[GEoffT]

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

 

[barx]

How are you initializing SQL1?

Are you trying to use the DB whilst it is in 'Assets'?

 

[GEoffT]

This is my initialization statement. I thought that this meant it was not in assets

SQL1.Initialize(File.DirRootExternal,"adcd.db",True)

 

[mc73]

Tried adding

sql1.TransactionSuccessful

just before the endTransaction line?
In general, I would avoid these try...catch blocks.
Finally, in executing queries such as 'select' there's no need of begin-end transaction.

 

[barx]

This is my initialization statement. I thought that this meant it was not in assets

SQL1.Initialize(File.DirRootExternal,"adcd.db",True)

Correct your not supposed to work with DB in assets, do you copy from assets to DirRootExternal first?

 

[GEoffT]

Correct your not supposed to work with DB in assets, do you copy from assets to DirRootExternal first?

No I dont! The db does not exist I thought the initialize would create it in the correct place.

 

[GEoffT]

Took the begin and end transaction and try-catch from around the first select and now it appears to work!