Active Topics
-
Is there a section to talk about Java ME? Apps, etc. (6)
to General by Kalatti - 5 days, 20 hrs ago - more...
| The Following User Says Thank You to evujumenuk For This Useful Post: | ||
|
2013-02-16
, 08:25
|
|
Posts: 435 |
Thanked: 769 times |
Joined on Apr 2010
|
#12
|
The correct SQL statement is:
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.
Code:
UPDATE Alarm SET Offset = 43200 WHERE Offset == -129600;
__________________
My Fremantle projects: InternetRadioPlayer, QRadio, InternetRadioWidget, AutoRemoveSms, PSAutoLock, TodoListWidget, MediaPlayerWidget
My Harmattan projects: InternetRadioPlayer, QMLRadio, SigmaPlayer, WidgetCanvas, NotesExporter, 3DTris, NoStopPlayer, NotesImporter
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: | ||
|
|
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:
If it looks right to you, then delete them (might want to make a backup copy of your db file beforehand):
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 ©.)
First take a look at what you will delete:
Code:
sqlite3 /home/user/.calendar/db 'SELECT * FROM Components WHERE "Type"="Todo"'
Code:
sqlite3 /home/user/.calendar/db 'DELETE FROM Components WHERE "Type"="Todo"'
(I know this does not really belong in this thread, but I just wanted to share this. Maybe someone should create a wiki entry ©.)
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!