How to save a record to SQLite permanent?

Databases
21

So the sequence might look like:

  1. Press Run
  2. Part of the “Run” build process copies the database into the Resources folder
  3. App runs (under the IDE) and updates the database
  4. App finishes and the debug build is deleted (that is, including the now-modified copy of the db)
  5. Original db is thus left untouched

If this is what’s going on, then either the example is poor, or the doc needs to be improved, or both.

But maybe all that’s needed is for a FolderItem that explicitly refers to the original file to be used.

22

This is not a decision you should rush. I took about two years to make my mind up, unfortunately at the time Xojo seemed to be running some blind alleys down which I went with them, only to realise I shouldn’t have done.

23

Yes, I did that in the end. Remains, why have a good feature that only keeps temporarily data. For a SQLite I could understand. But it is fully organized for different databases. Even has some kind of version control. Why go through all this trouble only the keep temporarily values? Doesn’t make sense.

24

Have-you tried to save the db file before quit with code i App.Closing ?

26

It doesn’t seem very useful does it?

Connecting in code is how it needs to be done.

27

Remember, when you hit Run to debug, the app is built in a fresh new directory, which is cleaned up / deleted when the app quits. Nothing is preserved.

If you don’t have a license yet and can’t Build the app, your only recourse is to store your database somewhere else and connect to it in code. It’s very easy, though.