I’m having difficulty working with an alert database table. i cant get the table to create automatically so i have created manually. most things appear to be working but i can not get the column Alert_Log_Id to populate. i currently do not have it as the primary key, when i tried creating as the primary key nothing got written to the table at all. I would like to use the ID as a method of easily selecting alarms in a table.
Since I can not get the ID to populate i am trying to select individual alarms using the Active_Timestamp column but am having trouble with the date format when i try to use it in my query’s.
Can someone either tell me how to get the log_Id to populate (preferable) or let me know the errors of my ways in my attempts to work with the timedate column?
thanks, Scott