|
|
|
It is currently Tue Jun 18, 2013 9:49 pm
|
View unanswered posts | View active topics | View unsolved topics
  |
Page 1 of 1
|
[ 2 posts ] |
|
| Author |
Message |
|
sydneydean
Trooper
Joined: Wed Nov 25, 2009 1:14 pm
Posts: 25
|
 Purging old Alarms We have been testing things out by triggering the alarms in the PLC program and generating some reports based on these alarms by querying the alarmlog table. When we get done testing and are ready to go live with the system, what is the preferred way of purging all the old logged data? Is it as simple as doing a truncate on the alarmlog table or will that break things?
|
| Fri Feb 12, 2010 8:12 am |
 |
 |
|
Colby.Clegg
Moderator
Joined: Sun Apr 02, 2006 3:43 pm
Posts: 2239
|
Re: Purging old Alarms Yes, you can just delete the data from the table. A "DELETE FROM alarmlog" query or similar would be fine.
FactorySQL doesn't rely on anything being in the log or status table, or assume that data will be there.
Regards,
_________________
Colby Clegg
Inductive Automation
Software Development
|
| Fri Feb 12, 2010 1:39 pm |
|
|
|
|
|
Page 1 of 1
|
[ 2 posts ] |
|
Who is online |
Users browsing this forum: No registered users and 1 guest |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum
|
|
