SQLITE and PRAGMA

[fatman]

Hi Erel,

in this old thread (http://www.b4x.com/forum/basic4android-updates-questions/13681-sqlite-wal-shm.html#post90354) you stated this code

sql.ExecNonQuery("PRAGMA journal_mode=DELETE")

My code is like that and returns an error at runtime:

SQL1.Initialize(mydir, Myfile, False)
'
SQL1.ExecNonQuery("PRAGMA journal_mode=DELETE")

If I delete the line with the pragma-statement my app is running fine...

What is wrong with the pragma-statement?

Thanx in advance

Fatman

 

[Erel]

Which Android version are you using? What is the error message?

 

[fatman]

Hi Erel,

I´m using Andoid 3.1 and the error message is:

android.database.sqlite.SQLiteException: unknown error: Queries can be performed using SQLiteDatabase query or rawQuery methods only.

The logs shows more or less the same.

Fatman

 

[Erel]

This command returns a value, so you should use:

   Dim c As Cursor
   c = sql.ExecQuery("PRAGMA journal_mode=DELETE")
   c.Close

 

[fatman]

Thank you very much Erel!
This helped me to increase the speed of my sqlite databases.

Fatman

 

[luciano deri]

Hi. How can read che pragma user_versione ? Thank you very much.

 

[Mahares]

You can do this:

Dim MyJournal As String
MyJournal=SQL1.ExecQuerySingleResult("PRAGMA Journal_mode") 
Log("Myjournal: " & MyJournal)  'displays the mode type of your database