• Replies 1 reply
  • Subscribers 585 subscribers
  • Views 171 views
  • Users 0 members are here
Options
Related

Adding fields to SQL alarm database

Donna

I am writing my Citect 2018 alarms to an SQL database for use by a third party.  They would like me to add an index into each record so that they can resume picking up our alarms at the correct place with no duplicates.

Has anyone done this before?  I've tried adding a custom field containing a variable, and added the extra column in my SQL device and SQL database, but only have blank columns.

Thanks!

  • We let SQL Server handle this by itself, by creating an extra column in the table called "id".
    This column should have the following properties:
    - Data Type = int
    - Allow Nulls = No
    - Identity Specification = Yes
        - Is Identity = Yes
        - Identity Increment = 1
        - Identity Seed = 1
    - Not For Replication = Yes
    We made this column the primary key as well.

    From SCADA we don't write to this column. It gets populated automatically.

© 2024 AVEVA Group Limited or its subsidiaries. All Rights Reserved.