I have written a trigger in TSQL that fires whenever a record is updated.
When the trigger fires I want it create an ole object, pass a string of
information from several fields to that object then that object will pass
this information to another database server using MSMQ. It all works fine
except for 1 small hitch. TSQL allows varchar or strings that are 255
characters in length. I have even built the string in a text field but I
cannot seem to pass that string to my ole object from the text field.
Any help would be greatful.
Corporate Information Services, City of Saskatoon
Phone: (306) 975-3196 FAX: (306) 975-2832