Support forum

Advanced Search

— Forum Scope —

— Match —

— Forum Options —

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

SQL Connector - MessageLog and MessageOut IDs?
sp_NewPost Add Reply sp_NewTopic Add Topic
January 25, 2016
9:01 am
Henk Helmantel
Forum Posts: 1502
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

Hello Robert,

The SQL Connector supports two fields that Diafaan SMS Server does not use and that is carried from the MessageOut to the MessageLog table, the 'UserId' field and the 'UserInfo' field. You can use either one of them to store your own message ID to keep track of the message status.

Regards, Henk

January 24, 2016
3:16 pm
Robert Covington

We've been developing using the SQL connector under the assumption that when inserting a row into the MessageOut table, the @@IDENTITY you get from it will be the same as the Id in the MessageLog table. However, after some thousand incoming/outgoing messages, this does not seem to be the case anymore. Is there any way to track messages between the two tables to confirm that the message has indeed been processed, and retrieve its status code and status text?

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 529

Currently Online:
9 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 678

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 1149

Posts: 3929

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 1502