concern

[coachvi]

CREATE TRIGGER trgInsteadOfUpdate1 ON dbo.Domod
INSTEAD OF INSERT
AS

-- Insert into Region
UPDATE OEORDD
SET EXTINVMISC != 0
FROM OEORDD INNER JOIN
Domod ON OEORDD.ORDUNIQ = Domod.ORDUNIQ
GO


kindly tell da problem want to update a table from a view table dat i ve created

 

[simian336]

!= means not equal.

You can't set a value not equal to something. You would have to set it equal to something.

Simi

 

[tcsbiz]

The != is not a valid assignment operator, use = instead. != (not equal) is valid in comparisons.

I keep trying to do something about my procrastination but I keep putting it off until tomorrow.

 

[markros]

In addition to other replies, perhaps you also want to join with the Inserted table, because otherwise this trigger doesn't make much sense. Also, the trigger is named InsteadOfUpdate but executed for INSTEAD OF INSERT and performs an update - I suspect it should be INSTEAD OF UPDATE trigger. Can you explain what this trigger is supposed to do to get better help?

PluralSight Learning Library

 

[coachvi]

here is the script of the table


USE [domdat]
GO

/****** Object: Table [dbo].[OEORDD] Script Date: 03/15/2012 09:18:28 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[OEORDD](
[ORDUNIQ] [decimal](19, 0) NOT NULL,
[LINENUM] [smallint] NOT NULL,
[AUDTDATE] [decimal](9, 0) NOT NULL,
[AUDTTIME] [decimal](9, 0) NOT NULL,
[AUDTUSER] [char](8) NOT NULL,
[AUDTORG] [char](6) NOT NULL,
[LINETYPE] [smallint] NOT NULL,
[ITEM] [char](24) NOT NULL,
[MISCCHARGE] [char](6) NOT NULL,
[DESC] [char](60) NOT NULL,
[ACCTSET] [char](6) NOT NULL,
[USERCOSTMD] [smallint] NOT NULL,
[PRICELIST] [char](6) NOT NULL,
[CATEGORY] [char](6) NOT NULL,
[LOCATION] [char](6) NOT NULL,
[PICKSEQ] [char](10) NOT NULL,
[EXPDATE] [decimal](9, 0) NOT NULL,
[STOCKITEM] [smallint] NOT NULL,
[QTYORDERED] [decimal](19, 4) NOT NULL,
[QTYSHIPPED] [decimal](19, 4) NOT NULL,
[QTYBACKORD] [decimal](19, 4) NOT NULL,
[QTYSHPTODT] [decimal](19, 4) NOT NULL,
[ORIGQTY] [decimal](19, 4) NOT NULL,
[QTYPO] [decimal](19, 4) NOT NULL,
[ORDUNIT] [char](10) NOT NULL,
[UNITCONV] [decimal](19, 6) NOT NULL,
[UNITPRICE] [decimal](19, 6) NOT NULL,
[PRICEOVER] [smallint] NOT NULL,
[UNITCOST] [decimal](19, 6) NOT NULL,
[MOSTREC] [decimal](19, 6) NOT NULL,
[STDCOST] [decimal](19, 6) NOT NULL,
[COST1] [decimal](19, 6) NOT NULL,
[COST2] [decimal](19, 6) NOT NULL,
[UNITPRCDEC] [smallint] NOT NULL,
[PRICEUNIT] [char](10) NOT NULL,
[PRIUNTPRC] [decimal](19, 6) NOT NULL,
[PRIUNTCONV] [decimal](19, 6) NOT NULL,
[PRIPERCENT] [decimal](9, 5) NOT NULL,
[PRIAMOUNT] [decimal](19, 3) NOT NULL,
[BASEUNIT] [char](10) NOT NULL,
[PRIBASPRC] [decimal](19, 6) NOT NULL,
[PRIBASCONV] [decimal](19, 6) NOT NULL,
[COSTUNIT] [char](10) NOT NULL,
[COSUNTCST] [decimal](19, 6) NOT NULL,
[COSUNTCONV] [decimal](19, 6) NOT NULL,
[EXTOPRICE] [decimal](19, 3) NOT NULL,
[EXTOCOST] [decimal](19, 3) NOT NULL,
[EXTINVMISC] [decimal](19, 3) NOT NULL,
[INVDISC] [decimal](19, 3) NOT NULL,
[EXTICOST] [decimal](19, 3) NOT NULL,
[EXTOVER] [smallint] NOT NULL,
[UNITWEIGHT] [decimal](19, 4) NOT NULL,
[EXTWEIGHT] [decimal](19, 4) NOT NULL,
[COMPLETE] [smallint] NOT NULL,
[ADDTOILOC] [smallint] NOT NULL,
[SALESLOST] [decimal](19, 3) NOT NULL,
[TAUTH1] [char](12) NOT NULL,
[TAUTH2] [char](12) NOT NULL,
[TAUTH3] [char](12) NOT NULL,
[TAUTH4] [char](12) NOT NULL,
[TAUTH5] [char](12) NOT NULL,
[TCLASS1] [smallint] NOT NULL,
[TCLASS2] [smallint] NOT NULL,
[TCLASS3] [smallint] NOT NULL,
[TCLASS4] [smallint] NOT NULL,
[TCLASS5] [smallint] NOT NULL,
[TINCLUDED1] [smallint] NOT NULL,
[TINCLUDED2] [smallint] NOT NULL,
[TINCLUDED3] [smallint] NOT NULL,
[TINCLUDED4] [smallint] NOT NULL,
[TINCLUDED5] [smallint] NOT NULL,
[TBASE1] [decimal](19, 3) NOT NULL,
[TBASE2] [decimal](19, 3) NOT NULL,
[TBASE3] [decimal](19, 3) NOT NULL,
[TBASE4] [decimal](19, 3) NOT NULL,
[TBASE5] [decimal](19, 3) NOT NULL,
[TAMOUNT1] [decimal](19, 3) NOT NULL,
[TAMOUNT2] [decimal](19, 3) NOT NULL,
[TAMOUNT3] [decimal](19, 3) NOT NULL,
[TAMOUNT4] [decimal](19, 3) NOT NULL,
[TAMOUNT5] [decimal](19, 3) NOT NULL,
[TRATE1] [decimal](15, 5) NOT NULL,
[TRATE2] [decimal](15, 5) NOT NULL,
[TRATE3] [decimal](15, 5) NOT NULL,
[TRATE4] [decimal](15, 5) NOT NULL,
[TRATE5] [decimal](15, 5) NOT NULL,
[DETAILNUM] [smallint] NOT NULL,
[COMMINST] [smallint] NOT NULL,
[GLNONSTKCR] [char](45) NOT NULL,
[AVGCOST] [decimal](19, 6) NOT NULL,
[LASTCOST] [decimal](19, 6) NOT NULL,
[COPYDETAIL] [smallint] NOT NULL,
[QUONUMBER] [char](22) NOT NULL,
[QUODTLNUM] [smallint] NOT NULL,
[SHIPTRACK] [char](36) NOT NULL,
[SHIPVIA] [char](6) NOT NULL,
[VIADESC] [char](60) NOT NULL,
[DISCPER] [decimal](9, 5) NOT NULL,
[QTYCOMMIT] [decimal](19, 4) NOT NULL,
[MANITEMNO] [char](24) NOT NULL,
[CUSTITEMNO] [char](24) NOT NULL,
[QTYTRUECOM] [decimal](19, 4) NOT NULL,
[VALUES] [int] NOT NULL,
[DDTLTYPE] [smallint] NOT NULL,
[DDTLNO] [char](6) NOT NULL,
[BUILDQTY] [decimal](19, 4) NOT NULL,
[BUILDUNIT] [char](10) NOT NULL,
[BLDUNTCONV] [decimal](19, 6) NOT NULL,
[FRMNUMBER] [char](22) NOT NULL,
[NEXTCMPNUM] [int] NOT NULL,
[EPOSPROMID] [smallint] NOT NULL,
[BASEWUNIT] [char](10) NOT NULL,
[WEIGHTUNIT] [char](10) NOT NULL,
[WEIGHTCONV] [decimal](19, 6) NOT NULL,
[PRWGHTUNIT] [char](10) NOT NULL,
[PRWGHTCONV] [decimal](19, 6) NOT NULL,
[PRIBASWCNV] [decimal](19, 6) NOT NULL,
[DEFUWEIGHT] [decimal](19, 4) NOT NULL,
[DEFEXTWGHT] [decimal](19, 4) NOT NULL,
[PRPRICEBY] [smallint] NOT NULL,
[NEEDPCHECK] [smallint] NOT NULL,
[CAPPROVEBY] [char](8) NOT NULL,
[HDRDISC] [decimal](19, 3) NOT NULL,
[OTRAMOUNT1] [decimal](19, 3) NOT NULL,
[OTRAMOUNT2] [decimal](19, 3) NOT NULL,
[OTRAMOUNT3] [decimal](19, 3) NOT NULL,
[OTRAMOUNT4] [decimal](19, 3) NOT NULL,
[OTRAMOUNT5] [decimal](19, 3) NOT NULL,
[PSPRINTED] [smallint] NOT NULL,
[JOBRELATED] [smallint] NOT NULL,
[CONTRACT] [char](16) NOT NULL,
[PROJECT] [char](16) NOT NULL,
[CCATEGORY] [char](16) NOT NULL,
[COSTCLASS] [smallint] NOT NULL,
[PROJSTYLE] [smallint] NOT NULL,
[PROJTYPE] [smallint] NOT NULL,
[REVREC] [smallint] NOT NULL,
[BILLTYPE] [smallint] NOT NULL,
[REVBILL] [char](45) NOT NULL,
[COGSWIP] [char](45) NOT NULL,
[RTGPERCENT] [decimal](9, 5) NOT NULL,
[RTGDAYS] [smallint] NOT NULL,
[PRICEOPT] [smallint] NOT NULL,
[ARITEMNO] [char](16) NOT NULL,
[ARUNIT] [char](10) NOT NULL,
[PAYMNTDIST] [decimal](19, 3) NOT NULL,
[SERIALQTY] [int] NOT NULL,
[LOTQTY] [decimal](19, 4) NOT NULL,
[SQTYMOVED] [int] NOT NULL,
[LQTYMOVED] [decimal](19, 4) NOT NULL,
[SLITEM] [smallint] NOT NULL,
CONSTRAINT [OEORDD_KEY_0] PRIMARY KEY CLUSTERED
(
[ORDUNIQ] ASC,
[LINENUM] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

 

[coachvi]

i ve created a view on the table


USE [domdat]
GO

/****** Object: View [dbo].[Domod] Script Date: 03/15/2012 09:21:42 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- Batch submitted through debugger: SQLQuery7.sql|11|0|C:\Users\ATG_Demo\AppData\Local\Temp\~vs11E0.sql
CREATE VIEW [dbo].[Domod]
AS
SELECT UNITPRICE * QTYORDERED * CAST(MANITEMNO AS Decimal(18, 3)) AS total, ORDUNIQ, EXTINVMISC,LINENUM
FROM dbEORDD
WHERE (ISNUMERIC(MANITEMNO) = 1)



GO

 

[coachvi]

now i want to create a trigger on this view to update this column ([EXTINVMISC] [decimal](19, 3) NOT NULL,) on the first table

kndly help me