Hello,



I'm trying to create a simple trigger on Delete using the Database Deployment ToolKit but when I attempt to deploy it I get:

Column tr_Schema does not belong to table DBETrigers



Have I missed something? The following is the body of the trigger. Thanks in advance for the help:





AFTER DELETE

AS

BEGIN



-- Prevent the result count from interfering

SET NOCOUNT ON;



-- Add trigger logic here

   if exists (Select 1 from Music m,deleted t

      where m.Artist_fk = t.Artist_pk)

      Begin

         goto error

      End

   return

error:

   raiserror 30006, 'Children exist in Music. Cannot delete this record'

END


Cory Cookson

Software Developer

Occupational Health Research

You are running an EXE that doesn't match the structure.  There is no longer a tr_Schema field in that table:

You can see the structure above.  I would recommend either download the install again and trying again (as I know that this is a solid build) or even trying the 1.6.7 beta.  This sounds like your DatabaseDTK.exe file is not being overridden which could be a permissions issue.  If you go into VS and click on the StrataFrame -> Version menu, it will show which EXE version you are running.  Also, you can see the structure for the DBETriggers table above.  So you have one or the other or both out of sync somehow.

You are absolutley right.  It looks like when I upgraded the DDT get overwritten correctly for some reason.

Seems to be ok now.

Thank you very much for the help!

Cory Cookson

Software Developer

Occupational Health Research

Glad you got it figured out