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.
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?
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 431
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 722