I really dont understand how SQLite works

Okay i been working for a while in a app, and actually what i need the SQLite to do its just store/save some values, names and numbers, that’s it, and for it to put it to other screens like a username where it shows u your current username that u changed in settings, but i want it offline, i don’t care about any internet connectivity its just a project that should work offline, and i tried lets say almost everything, other SQLite premade ones (they work in lists, and i just need individual values in a text box), tried tutorials but something that seems so simple like, i type in a text box, and when i press de button, that text goes to the label (i would prefer just SQLite because it saves the data) doesn’t seem simple at all, i tried many ways to do that simple “send text-box text-data to BD” then “retrieve text-box text-data to label” with a button click and i want to use text-box text-data in other screens too, but this is the only app that i struggled the most in doing that simple thing, can somebody help me, or send a example of what blocks should i use for just that, a thing with just one button, the button saves the data from textbox and updates the labels (with the text data), and preferably many text boxes

(edit) i have to add that most of the time i tried to do that, sql saves it in a list form, or doesnt even save the data i want it to, and the worst worst, i dont manage to make it show the textbox text in the label, and i need a way for it to be just 1 row, no more than one, and other one with no more than 4 rows

Use TinyDB
Taifun

i have a question, does that extension like, lets say i close the app for a whiiile, lets put it days, and i open it again, it will have the same data i inputted the last time? and how do i do for like move the values between screens?

Which extension are you talking about?
Both TinyDB and Sqlite are components

A very good way to learn App Inventor or Kodular is to read the free Inventor’s Manual here in the AI2 free online eBook App Inventor 2 Book: Create Your Own Android Apps … the links are at the bottom of the Web page. The book ‘teaches’ users how to program with AI2 blocks.

There is a free programming course here Course In A Box and the aia files for the projects in the book are here: App Inventor 2 Book: Create Your Own Android Apps

How to do a lot of basic things with App Inventor are described here: How do you...? .

Also do the tutorials Our Tutorials! to learn the basics of App Inventor, then try something and follow the Top 5 Tips: How to learn App Inventor

Taifun

1 Like

oh yeah that, components, not really familiarized to anything sorry, but thank you for your feedback, ill check the links, have a great day!