Android Question Disabling WAL for SQLite database on Android 9

[nickkat]

It seems android 9 is enabling by default SQLite databases to use journal mode WAL.
How can I disable this?

I have tried the following but it doesn't seem to do work.

 Dim c As Cursor
c = SQL.ExecQuery("pragma journal_mode=delete")
c.Close

 

[Erel]

Please use [code]code here...[/code] tags when posting code.

If p.SdkVersion >= 26 Then
   Dim r As Reflector
   r.Target = sql
   r.Target = r.GetField("db")
   r.RunMethod("disableWriteAheadLogging")
End If