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 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%] ) }