Page 2 of 2 1 2
Reply
Thread Tools
evujumenuk is offline evujumenuk
2013-02-16 , 07:41
Posts: 123 | Thanked: 91 times | Joined on Apr 2012
#11
Hello all.
I am trying to make my birthday reminders pop-up in the same day as the birthday...say at 12 in the afternoon.
I tried "UPDATE Alarm SET isEnabled = 1 WHERE Offset == 43200;"

Nothing seems to happen.

If I enter "UPDATE Alarm SET isEnabled = 0 WHERE Offset == -129600;" the alarms stop working witch means that the command is working.

Some ideas???

Thanks!
 

The Following User Says Thank You to evujumenuk For This Useful Post:
gionni88 is offline gionni88
2013-02-16 , 08:25
Posts: 435 | Thanked: 769 times | Joined on Apr 2010
#12
The correct SQL statement is:

Code:
UPDATE Alarm SET Offset = 43200 WHERE Offset == -129600;
I have not checked if a positive offset can be set by the way. Be carefull when entering SQL statements, you may harm the database without even knowing it.
__________________
My Fremantle projects: InternetRadioPlayer, QRadio, InternetRadioWidget, AutoRemoveSms, PSAutoLock, TodoListWidget, MediaPlayerWidget
My Harmattan projects: InternetRadioPlayer, QMLRadio, SigmaPlayer, WidgetCanvas, NotesExporter, 3DTris, NoStopPlayer, NotesImporter
 

The Following 2 Users Say Thank You to gionni88 For This Useful Post:
evujumenuk is offline evujumenuk
2013-02-16 , 11:21
Posts: 123 | Thanked: 91 times | Joined on Apr 2012
#13
it worked. Thanks a lot!
 
whisk4s is offline whisk4s
2013-02-23 , 21:02
Posts: 35 | Thanked: 60 times | Joined on Sep 2011
#14
I just figured out a way to delete all ToDo entries in the calendar.

First take a look at what you will delete:
Code:
sqlite3 /home/user/.calendar/db 'SELECT * FROM Components WHERE "Type"="Todo"'
If it looks right to you, then delete them (might want to make a backup copy of your db file beforehand):
Code:
sqlite3 /home/user/.calendar/db 'DELETE FROM Components WHERE "Type"="Todo"'
After a reboot the entries will be gone.

(I know this does not really belong in this thread, but I just wanted to share this. Maybe someone should create a wiki entry ©.)
 
Reply
Page 2 of 2 1 2

Tags
thanks gionni88

« Previous Thread | Next Thread »
Thread Tools

 
Forum Jump


All times are GMT. The time now is 03:42.

Contact Us - Home - Archive - Top