[RESOLVED] [vbRichClient] SQLite Pragma and Foreign Key support.

[7edm]

Hi Olaf,

I hope you will see this.

I'm trying to switch On SQLite Foreign Key support in RC5 but without success :-(

While

Call con.Execute("PRAGMA user_version = 1")

seam to work and set assigned value

Call con.Execute("PRAGMA foreign_keys = 1")

doesn't

Have you stripped out the FK support in the RC SQLite library or what, and if so for what reason?

If this simply is a bug no one have come across yet, this is one more observation that may or may not have something to do with it.

When Using the "PRAGMA" statement to open a recordset (I cannot see any other way to read a DB setting value, although I may have missed it) like

Set rs = con.OpenRecordset("PRAGMA user_version")

rs(0).Updatable always equals False and same with rs.Updatable

while for e.g.

Set rs = con.OpenRecordset("SELECT value FROM config WHERE name = 'setting'")

behave as you would expect it depending on if optional ReadOnly arg is set or not.

And while you are on it, maybe you could update the sqlite version as well, as the current on used by RC5 isn't among the recommended ones by upstream ;-)

/Joakim