The 1001 questions about vbRichClient5 (2020-07-21)

[dreammanor]

Question 40: How to set auto_vacuum setting on a new sqlite database?

The following attempt fails with "Sorry, no open DataBase!" error

    Dim oConn As cConnection
    
    Set oConn = New cConnection
    oConn.Execute "PRAGMA auto_vacuum=incremental"
    oConn.Execute "PRAGMA journal_mode=WAL"
    oConn.CreateNewDB "D:\TEMP\aaa.db"

There are 4 pragmas that one might need to set before creating a new database and/or issuing other pragmas (like journal_mode).

These were listed on sqlite-users mailing list as:
- pragma auto_vacuum
- pragma encoding
- pragma page_size
- pragma data_store_directory

cheers,
</wqw>

Hi wqweto, thanks for your question. I've put your question on the list in post#1.