Cory,

I totally missed this post until just now...in the future don't be afraid to post a "bump" post if it has been more than a couple of days!

At any rate, it looks as though you have loaded a more recent version of the DDT but didn't update the StrataFrame structures.  Also, you will need to re-create your packages once the new update is installed as well as some of the column structures have changed.  It should be pretty straight forward:

1. Load the new update and be sure to allow the data structures to be updated
2. Go back into your DDT project and rebuild the deployment package
3. You should be good to go at this point

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