Default SQL template examples
You can use the following example templates in all cases that a message is 'Received', 'Accepted for delivery', 'Delivered to network', 'Delivered to handset' and has 'Delivery error'. These SQL statements will run every time one of these five message events occur in Ozeki SMS Gateway.Received:
This example template INSERT-s every incoming message to the 'inbox' table.
Accepted for delivery:
You can INSERT messages in the 'outbox' table before broadcasting them with Ozeki SMS Gateway.
Delivered to network:
UPDATE-s the message record before delivering it to the network. For example it changes the message status.
Delivered to handset:
UPDATE-s the message record before delivering it to the recipient's handset by changing the message status.
UPDATE-s the message record in case of an error. It also saves the error message as well.
You can find these SQL examples in the field boxes