Open encrypted or not encrypted SQLite

Opening a SQLite Database when is not known if is or not encrypted.

I thought that if the DB is encrypted the Try should Catch the error and allow to try again with a password, but Xojo crashes at the point.

How to know if we are trying to open a encrypted or not encrypted SQLite db?

The code works ok on not encrypted DDBB if db.EncryptionKey is commented and, works ok on encrypted db.EncryptionKey if it is not commented.

image

Sorry found the solution. Xojo stops execution because Break in Exceptions was checked.

Forum for Xojo Programming Language and IDE. Copyright © 2021 Xojo, Inc.