I have an SQLite read-only database that I would like to (1) be embedded within my app, (2) open when my app opens without the user opening a folder then selecting the database, and (3) fill records into text fields rather than a listbox. I have Googled, and I have tried some examples from various forum responses, and I have followed a few YouTube videos, but I just cannot get it to "click." I was able to load it by selecting a directory or folder, now I'm convinced that was by accident. My latest effort was from watching a video on database connections by Paul Lefebrvre. I thought surely I had found my solution by adding his instructions but I still get errors on running.
My app is an algebra game I created using MicroSoft's Visual Studio, but since I've discovered Xojo (I purchased a Mac edition license), I thought it would be great to port it over to the Mac desktop platform as well. I simply don't want my SQLite database edited, or corrupted by a user, as I painstaking created over 580 algebra questions each with multiple choice responses. I'm frustrated because this problem is preventing my success. Is their help for me?