Support forum

sp_Search Search
Advanced Search
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Search Search
Go to Bottom
sp_TopicIcon
MessageOut->MessageTo column length
sp_NewPost Add Reply sp_NewTopic Add Topic
July 12, 2023
2:49 pm
Richard
Guest
Guests
Go to Top
3sp_Permalink sp_Print sp_QuotePost Quote

Excellent. Thanks Henk. Will change the column size

July 12, 2023
9:14 am
Henk Helmantel
Admin
Forum Posts: 1472
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
2sp_Permalink sp_Print sp_QuotePost Quote

Hello Richard,

If you have a large list of comma separated numbers in the MessageTo field, you can use a larger MessageTo column definition in the MessageOut database table. The SQL Connector does not have a fixed length limit when it reads in this field, you can change the field definition to nvarchar(max) or to a lower size.

Regards, Henk

July 11, 2023
8:12 pm
Richard
Guest
Guests
Go to Top
1sp_Permalink sp_Print sp_QuotePost Quote

Hello.
MessageOut->MessageTo column length is defined as a nvarchar(80)
Is there a way to change this? We have currently a string of numbers that adds up to 230 characters.
Or do we need to split the mesaage up into like 11 separate messages?

sp_NewPost Add Reply sp_NewTopic Add Topic
Go to top
Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
2 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 668

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1131

Posts: 3858

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1472