Bookmarks: | Page Index | Recent Changes | Recently Commented | Users | Registration |
Microsoft SQL Server supports a very powerful SQL dialect. A lot of our customers prefer to use SmsRc just as a gateway between the phone and the server, implementing all SMS-handling logic in the server's stored procedures.
For this type of project, the file with just one ўўhttp://sw4me.com/wiki/SMSReceptionCenter/actions/ExecuteSQL ==ExecuteSQLЇЇ action must be created. The SQL statement must call the stored procedure that is ready to handle incoming messages. Using appropriate ODBC escape sequence, the statement will look like this one:
{ CALL sp_incoming_sms ( [%Timestamp%], [%Sender%] , [%Message%] ) }
There are two ways to send the answer from the stored procedure.
CREATE TABLE OutgoingSMs (
[MsgID] int IDENTITY (1, 1) NOT NULL ,
[MsgText] nvarchar (254) NOT NULL ,
[MsgStatus] int NOT NULL ,
[MsgTarget] varchar (12) NOT NULL
) ON [PRIMARY]
GO