Very Computer

by **David Lawrenc** » Sat, 06 Feb 1999 04:00:00

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.

David Lawrence
Programmer Analyst

Corporate Information Services, City of Saskatoon

Phone: (306) 975-3196 FAX: (306) 975-2832

by **Gianluca Hot** » Wed, 10 Feb 1999 04:00:00

>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.

Never tried it, maybe there's a workaround.
Otherwise the only solutions I see are either splitting
your string and code your object to handle the submission
of multiple chunks or try it with SQL Server 7.0 that
allows char and varchar fields to have up to 8000 chars.

HTH
--
Gianluca Hotz
MVP + MCP SQL Server and MCP Windows
http://users.alphasys.it/ghotz

by **David Lawrenc** » Thu, 11 Feb 1999 04:00:00

Thanks that is what I did is split it into multiple chunks

DL

>>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.

>Never tried it, maybe there's a workaround.
>Otherwise the only solutions I see are either splitting
>your string and code your object to handle the submission
>of multiple chunks or try it with SQL Server 7.0 that
>allows char and varchar fields to have up to 8000 chars.

>HTH
>--
>Gianluca Hotz
>MVP + MCP SQL Server and MCP Windows
>http://users.alphasys.it/ghotz

Very Computer

Help ... Need to send a long string from SQL to a VB object.

Help ... Need to send a long string from SQL to a VB object.

Help ... Need to send a long string from SQL to a VB object.

Help ... Need to send a long string from SQL to a VB object.