SQL Query to SMS Service (Delphi 7)
Flow: SQL Query Service (what you need to create) --> TCP --> SMS Server
1). Able to create/edit/delete more than 1 thread (i'm calling it campaign).
2). Use Zeoslib component to query mssql, mysql, postgresql, oracle (local/remote). Sample code will be provided as I have done this previously in another project. I'll provide all the dlls. You just have to test.
3). Each thread will need to query the SQL db (DB connection settings configurable) to fetch data (fields), and then submit the data to a socket server (using indy 9 tcp client). I'll provide the indy 9 code for tcp client as i've done other project using that socket server. The socket server is actually on an sms service.
4). After transmitting the message, you'll also need to execute another SQL query (using another set of DB connection settings).
5). Provide GUI client (See attached demo [url removed, login to view] which i did while confirming the specifications with the user). Service should pickup changes made to the client within a couple of seconds.
6). Code should be well commented. Before starting on the project, you'll be to write the specifications in detail to clear any possible misunderstanding. You'll also need to provide GUI mockup screens before commencing on logic coding. All this must be presented in word doc format.
7). Coder is expected to test the application before uploading to RAC.
8). Unless you reply to RAC posts very promptly, MSN communication is required.
Note: With regards to [url removed, login to view], this is only what i did to present to the client, and is not final you must provide a better and more user friend solution! Also, about the schedule grid, i took it from another project so I will provide the code to the selected coder.
This is a brief requirement, details will be provided later for your final bid. Please provide a budgetary quote and time you require to implement. Please do not bid unless you are highly skilled delphi programmer.
Please let me know if you have any questions. Also, provide details of Delphi applications you have created, links, demos, etc.