ListBox & DB Interactions
Been some time. Was busy setting-up a new office in Kuala Lumpur. In between activities, I spared some time in transforming our previous project. Move over Text Files, here comes SQLite database.
The SQLite DB file is located in MyDocs (XP/P8/ME) or Documents (Vista) hosted in the folder named as MyResourceFolder. The folder and DB file will be created automatically when launching this App.
Some minor changes were made to the interface. I’ve also added more details but the functions remain the same:
1. Add New Entry
2. Delete Entries
3. Edit Entries
4. Search Entries
5. Group Entries
6. Rename Groups
7. Delete Groups
8. Share Items between Groups
9. Make a New Group from Search Results
10. Validate All Entries
Since this Project uses SQLite, we have removed previous concerns. We can now
1. Update Entries shared by several Groups all at once
2. Search every row in the DB directly without any help from ListBox.
For each item ( every DB row ), you might only see 4 data on the interface. In actual fact, this project is prepared for more than 10 data per item. This includes the usual suspects like Address, Zip Code, Street Name, Country, Birthday, Description, Notation and etc. I encourage readers to try embed more entries at the interface. This is the way to learn.
If you add Dermot’s Pop3 Plugin, you’re making an almost full-featured Email App. To learn more about SQlite DB on AMS, please view TJ Tigger’s Video.
Please Login or Register to download this file.
In the next topic on Mini Address Book, I plan to add 2 more features:
1. Photo for each Name
2. Calendaring.
We’ll see how it goes. If there is a request, I will make create another example just for the Search Function. Please use the comment in the Blog.
And please, leave your comments in this blog.







Am new to both this field of ams, lua and even programing but am enjoying this. This is making sense to me. I can i request to please that you expand the search features so that it is possible for me will to search for either first name and surname at the same time. On top of that, when i search for FirstName HLBterence P S using search text HLBterence S P the application does not find it, is the a way to improve this feature.
Hey there nice…
Well done i will use this personal data and sealf learning thanks for sharing…
Greets from Mexico…
Remember Enjoy Life Any How…
Quote [To learn more about SQlite DB on AMS, please view TJ Tigger’s Video.] Quote
Where is the link to the video?
Thanks
Ok I see the link on the sidebar
http://www.tj-tigger.com/pub/TiggTV/TiggTV.html
nice
than’s man
An excellent exampl, I am sure I will Learn a lot from it.
Many thanks for your time in this forum.