Page 2 of 2 1 2
Reply
Thread Tools Search this Thread
evujumenuk is offline evujumenuk
02-16-2013 , 03:41 AM
Posts: 102 | Thanked: 57 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
02-16-2013 , 04:25 AM
Posts: 435 | Thanked: 756 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
02-16-2013 , 07:21 AM
Posts: 102 | Thanked: 57 times | Joined on Apr 2012
#13
it worked. Thanks a lot!
 
whisk4s is offline whisk4s
02-23-2013 , 05:02 PM
Posts: 25 | Thanked: 24 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 Search this Thread
Search this Thread:

Advanced Search

 
Forum Jump


All times are GMT -4. The time now is 04:08 PM.

Contact Us - Home - Archive - Top