Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

sp_TopicIcon
MessageOut->MessageTo column length
sp_NewPost Add Reply sp_NewTopic Add Topic
July 12, 2023
2:49 pm
Richard
Guest
Guests

Excellent. Thanks Henk. Will change the column size

July 12, 2023
9:14 am
Henk Helmantel
Admin
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

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?

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
4 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 677

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3928

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502