SQLite function to Save Properties & Data

Got a LiveCode personal license? Are you a beginner, hobbyist or educator that's new to LiveCode? This forum is the place to go for help getting started. Welcome!

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller

Post Reply
townsend
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 430
Joined: Sun Feb 13, 2011 8:43 pm

SQLite function to Save Properties & Data

Post by townsend » Tue Dec 17, 2013 9:24 pm

A while back, I was concerned about saving properties, text, and configuration data, without having to save the entire stack, which I knew would be problematic in mobile environments. So I wrote this single function that could be dropped into any one of my stacks, allowing me to easily save and retrieve data in a simple SQLite table.

Just recently I needed to use it again, and saw it was done as quick hack. And though it worked, was not very well written. I liked the concept, so I've completely re-written it, so now, it not only works, but the code is very readable, and usable by others.
db-Data-function.zip
(3.21 KiB) Downloaded 201 times
055 dbData.JPG
1- Place your app's name in the "folder.name" variable.
2- Use the "file.name" variable to define a name for your SQLite db file.
3- Then just paste the dbData() into the Stack Script area of your app.

Let me know if you have any questions or concerns.

Post Reply