Store multiple day value in single entry in sqlite

Question

i want to store multiple day values like Sunday, Friday etc.. in my database with single entry for recurring alert purpose see my below image

In this above image i check Sunday, Wednesday, Friday so in my database entry should be single with multiple days and also give me reminder as per selected day so any idea how can achieve this? your all suggestions are appreciable

MY Query is how can i insert multiple days in single entry in my database which give me recurring alert? Which database structure should i follow which fulfill my requirements?

virendrao:but when i want to update thatdata than how can i make it possible? — Harshal Kalavadiya, Dec 17 '15 at 10:15
when you update you will get all days again as you want to show whats already there first before allowing user to update. So just updated those all values as a string on previous values. ie similar to delete old update new — virendrao, Dec 17 '15 at 10:17
use comma, when update delete old and insert new list as comma seperated string. — ondermerol, Dec 17 '15 at 10:17
better you make another table and link your original table by id — Sree, Dec 17 '15 at 10:19
Just an idea: Something like a positional string: `1001010` or `S--W-F-` could make it. — Phantômaxx, Dec 17 '15 at 10:20
Frank N. Stein: your suggestion is right for insert and update but what about alert? how can i send alert with 1001010 string ? — Harshal Kalavadiya, Dec 17 '15 at 10:25
I mean you just create another table where you can store all the details of the week and link that table to your current table by id, so that you can easily select — Sree, Dec 17 '15 at 10:27
Simply loop over the string and find out which are the days to set the alarms on and off. — Phantômaxx, Dec 17 '15 at 10:34

score 0 · Answer 1 · answered Dec 17 '15 at 10:33

0

As mention by @shree in comments you can create separate tables and link them via foreign key

answered Dec 17 '15 at 10:33

koutuk

832
1
8
17

Store multiple day value in single entry in sqlite

1 Answers1