Figure 15 - Connection string for the user
Now click on "SQL for sending" tab and modify the SQL update
statements. To do so, you need to delete the apostrophes after "WHERE id=" part
in the update statements. First go to "Sending" tab and modify the "UPDATE"
statement in a way that the final statement should look like this (Figure 16):
Figure 16 - SQL statement for sending
Then you need to modify other update statements as well. The
statement in "Sent" tab is (Figure 17):
Figure 17 - SQL statement for sent
The statement in "Not sent" tab is (Figure 18):
Figure 18 - SQL statement for not sent
The statement in "Delivered" tab is (Figure 19):
Figure 19 - SQL statement for delivered
The SQL statement in "Undelivered" tab is (Figure 20)
Figure 20 - SQL statement for undelivered
In order to demonstrate this process in a better way I enable "Log SQL SELECT statements" and "Log SQL UPDATE statements" (Figure 21).
Figure 21 - Logging
To test the system click on "SQL Prompt" menu item and select the following statement from the dropdown menu: "INSERT INTO ozekimessageout (receiver,msg,status) VALUES ('+36205460691' , 'Hello World' , 'send');" Then click on "Execute" (Figure 22). This SQL statement will insert a row into "ozekimessageout" table which will be sent out by Ozeki NG SMS Gateway as an SMS message.
Figure 22 - Create an outgoing message
If you inserted the outgoing message into "ozekimessageout" table, after a short period of time you can see in the "Events" of the created database user that the outgoing message has been found and updated by Ozeki NG SMS Gateway and finally it has been sent as an SMS message (Figure 23).
Figure 23 - Found outgoing message
The sent message can be seen in the "Outbox" of the created database user (Figure 24).
Figure 24 - Sent message of database user
For demonstrating incoming messages I will simulate an incoming message over SMPP connection (Figure 25).
Figure 25 - Received message
By clicking on the "Events" of the created database user it can be seen that the incoming message has been inserted into "ozekimessagein" table (Figure 26).
Figure 26 - Inserted message
To see the incoming message click on "SQL Prompt" menu item and select "SELECT*FROM ozekimessagein" statement and click on "Execute" (Figure 27).
Figure 27 - Select fields from ozekimessagein
As a result the received message can be seen (Figure 28).
Figure 28 - Received message
Visual FoxPro with Ozeki NG SMS Gateway is the best solution if you wish to implement an efficient SMS system in your corporate IT network. Ozeki's solution makes it possible to send important data and information from Visual FoxPro to multiple mobile phones if it is required. With this solution you will gain a stable, well-functioning and secure SMS system that is easy to work with and save valuable time and money.
Request more information
If you are interested in this solution, let us know, so we can send you more relevant information and quotation with prices. Please fill in the following form:
|Home > Applications > SQL database > Visual FoxPro|
Feel free to contact us for additional information. Tel: (36) 52 532 731, Fax: (36) 52 532 732,
E-mail: info @ ozekisms.com|
Copyright © 2000 - 2013 Ozeki Informatics Ltd. - All rights reserved.