triggers

    Hi!
    I need to create some triggers on DICOMImage and DICOMPatient tables (of a MSSQL Server database)so that when inserting any new image, some records are copied onto another table of another database. If I create the triggers directly from the database they are obviously deleted when regenerating the database. What should I do to avoid this problem? Should I edit the dbsql.cpp and then recompile?
    Thank you
    Lisa

    Hi,


    I guess you need to do that. The database tables are deleted as part of the regen and that will delete the triggers I presume. The alternative would be to add a function to clear the tables without dropping them (e.g., dgate --cleartables:).


    Marcel

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login