10-29-2019 10:45 AM
Hello,
I can read, write, delete value from file .DB of SQLite, but when I make a password for database of SQLite by software DB Browser for SQLite, I don't know, how to open this file SQLite by Labview. Please help me find the best solution.
Thanks.
10-29-2019 11:06 AM
Based on the screenshot you gave, it's not (easily, at least) possible.
The encryption isn't a part of SQLite3, and is instead being done by the program you're using.
Although that program might have documentation to allow you to decrypt the file before opening it in LabVIEW (either by DLL call through the Call Library Function Node, or by programming a decryption algorithm based on the information they may or may not give, and the password you know), it's not likely to be very easy.
The simplest solution is to not encrypt your file.
The next simplest (assuming you want to encrypt the file) is to use a library (separate from the DB Browser you mentioned) that can encrypt and decrypt files using a command line interface, and use that to encrypt and decrypt your .db file. That's all the sqlite database is - a file.