Alarm Logging to ODBC Datatbase


Recommended Posts

When I enable alarm logging to a database, I get an error indicating that field types are incorrect. It seems like I need to setup the field names in a similar manner to the logging area (ie, using the SQL button to change the field name to REAL or Float from Single).


Link to comment
Share on other sites

Alas, we don't have that functionality for the alarm logging.

However, you could always just pre-create the table yourself using the correct sql field types. If the table is already created and the field names are correct, DF won't try and create the table. Here is the create line it uses:

CREATE TABLE ALARMLOG (TheTime DATE, Name TEXT(100), Description TEXT(255), Priority SHORT, Status TEXT(1));

Keep the table and field names the same, but you should be able to change the types.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.