Thanks guys...the alias in the view was different..problem all solved :) -----Original Message----- From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Mark Hurd Sent: Wednesday, 4 May 2011 2:11 PM To: ozDotNet Subject: Re: Non Standard Column Names
I'm not on SQLDownUnder, but is the problem that [Test ID] is an autoincrement column and so is not included in the Inserted columns? -- Regards, Mark Hurd, B.Sc.(Ma.)(Hons.) On 4 May 2011 12:18, Anthony <asale...@tpg.com.au> wrote: > Oops..wrong group..sorry > > From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com] > On Behalf Of Anthony > Sent: Wednesday, 4 May 2011 12:16 PM > To: 'ozDotNet' > Subject: Non Standard Column Names > > > > alter TRIGGER [dbo].[trgTest] ON dbo.vwTest > > INSTEAD OF UPDATE > > > > AS > > > > BEGIN > > SET NOCOUNT ON > > --I cannot chnage field names..yes...very bad field names! > > UPDATE Debt > > SET [Print Filecover?]=Ins.[Print Filecover?] > > FROM Debt > > INNER JOIN inserted AS Ins ON Debt.[Test ID] = Ins.[Test ID] > > > > END > > Anyone explain why i get error Invalid column name 'Test ID'.