Table_GetCursor: SELECT IntervalHour,IntervalMinutes,AlarmTime,SleepTime,TimeRemaining FROM SiteIntervals WHERE OnOff = 'Y' AND AlarmTime >= '05:18' ORDER BY AlarmTime
* open timedialog and create new alarm
5:30
48 05:48:00
Alarm: 100080000
InsertMaps (first query out of 1): INSERT INTO [SiteIntervals] ([ID], [SiteID], [AlarmTime], [OnOff], [IntervalHour], [IntervalMinutes], [SleepTime], [TimerDate], [TimeRemaining]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
ExecuteCSV: SELECT ID, AlarmTime, OnOff from SiteIntervals where SiteID = '125045' order by AlarmTime
Table_GetCursor: SELECT * FROM SiteIntervals
2:36
54 02:54:00
Alarm: 89640000
UpdateRecord: UPDATE [SiteIntervals] SET [SleepTime] = ? WHERE [ID] = ?
UpdateRecord: UPDATE [SiteIntervals] SET [TimerDate] = ? WHERE [ID] = ?
UpdateRecord: UPDATE [SiteIntervals] SET [TimeRemaining] = ? WHERE [ID] = ?