Android Question Contact Database Sample

[Bhrt60]

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]

As there are only about a 200 Contacts I think SQLLite DB can be used

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]

Did you have a look at chapter 5 SQLite Database in the B4A User's Guide?