July 14, 2005 at 12:27 am
hi
first of all i m sorry in advance for any mistakes cause i m not very familiar with this site.
i m facing a perculiar problem with triggers. i m not able to create trigger on a table having a "text" type field. and error is displayed everytime i create a trigger on any such table...
is there no way a trigger can be created on a table having "Text" type field????
please help..
thanx
July 14, 2005 at 5:34 am
what kind of trigger is it ?! what is the ddl of the table that the trigger is set on ? what is the syntax of the trigger ? what error msg. do you get ?
**ASCII stupid question, get a stupid ANSI !!!**
July 14, 2005 at 9:43 am
"text" data type is not available in AFTER triggers but it is in INSTEAD OF triggers. Use the latter if you need access to such columns in the trigger!
Cheers!
* Noel
July 14, 2005 at 5:40 pm
if you're creating a trigger where you compare against a text type it won't work.
Eg. where table.textfield = inserted.textfield -- this won't work!!!
Cannot do a 'straight' compare for the text, ntext or image types.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply