B Bhrt60 Member Licensed User Jan 14, 2017 #1 I'm need to Create a Contact Database and record activities for contacts I've searched the Examples - NO LUCK !! I can't see any examples that would help me get started. May be I'm asking the wrong questions! First I need to create the Contact database --Contact Table-- AccountID Name Address City ... Telephone Mobile biz email personal email Various other info - would nice to setup 2-3 Tabs for this --Activity Table-- Ideally displayed in a List with option to add/edit AccountID Date Activity Type Notes Complete | Active Next Contact Date As there are only about a 200 Contacts I think SQLLite DB can be used Any pointers / sample would be appreciated
I'm need to Create a Contact Database and record activities for contacts I've searched the Examples - NO LUCK !! I can't see any examples that would help me get started. May be I'm asking the wrong questions! First I need to create the Contact database --Contact Table-- AccountID Name Address City ... Telephone Mobile biz email personal email Various other info - would nice to setup 2-3 Tabs for this --Activity Table-- Ideally displayed in a List with option to add/edit AccountID Date Activity Type Notes Complete | Active Next Contact Date As there are only about a 200 Contacts I think SQLLite DB can be used Any pointers / sample would be appreciated
Erel B4X founder Staff member Licensed User Longtime User Jan 15, 2017 #2 Bhrt60 said: As there are only about a 200 Contacts I think SQLLite DB can be used Click to expand... SQLite DB can also be used if there are 2 million contacts. Accessing the contacts: https://www.b4x.com/android/forum/threads/30824/#content Databases: https://www.b4x.com/android/forum/threads/sql-tutorial.6736/#content (also check DBUtils). Upvote 0
Bhrt60 said: As there are only about a 200 Contacts I think SQLLite DB can be used Click to expand... SQLite DB can also be used if there are 2 million contacts. Accessing the contacts: https://www.b4x.com/android/forum/threads/30824/#content Databases: https://www.b4x.com/android/forum/threads/sql-tutorial.6736/#content (also check DBUtils).
klaus Expert Licensed User Longtime User Jan 15, 2017 #3 Did you have a look at chapter 5 SQLite Database in the B4A User's Guide? Upvote 0