DBTexBox

[Dario126]

For small application which uses 20 or 30 records, each of them is cca 15 fields, what is best way do design application?

Is it better to store data in dynamic array or SQLite is not big overkill for average phone?

How to represent data on screen. If I put some TextBox on screen, is there some way that TextBox is connected with certain (SQlite) field, so that programmer thus not have to fill all TextBoxes each time record changes, or to update database if user changes some value in TextBox? Something like DBTextBox control in some desktop RAD packages..

:sign0104:

 

[mc73]

If your data table is that small, perhaps you can handle it with a random access file. You can even want to try Margret's db class.
A textbox cannot be automatically updated, you have to do it manually (at least so I know). However, there is the dbUtils module by Erel, which can surely be a great help.

 

[wheretheidivides]

use margets db class. very easy to use. You can have a label that is someone clicks a dialog box pops up for input or have a editext field and when the person clicks done, the edittext info is saved to a variable (or even updates db).

I'd say just have a panel with all 15 fields on it with editext boxes. When the person clicks done, have it save the input to a variable and then update record. That's it. Margets db class demo have list, previous, next, first, last, delete and so forth. very easy to do.

or when the person clicks update button, have all editext info saved to variable and then updated at the same time. This allow someone to click don't save button.