Posts

Showing posts from September, 2006
Another Delphi tool that I've been working with has been the Indy components. I've been using them for doing e-mail directly in my apps. I currently use the latest snapshot of the components (the web-site has instructions how to install the components) and make sure you use the OpenSSL libs (older versions need a special set of OpenSSL libs, but the newer version uses the regular libs). The problem I'm trying to solve with this is that there are offices in various states which need to send partial employee information to the organization headquarters on a monthly basis. In turn, on occasion, the headquarters might send an update to one or more of the offices. Integrating e-mail has the advantage of reducing the number of steps required to complete the task. Of course, doing this increases the complexity of the application and this increases the risk that the program will produce errors (and discourage end users). The features that this code has are as follows: 1. Conf...
In my last entry I wrote a script to handle saving a schema (to a python pickle file), restoring the schema, and doing backup and restore. After I wrote the script, I compiled it using the py2exe utility so that I could send the script with my Delphi app. In my Delphi app, I created a sub-folder called "pyscript" and stored the compiled files in that folder. The following is the code that I have for a form that interfaces with my MySQL schema script. Note the conflicting names. My script has schema in the name, but my Delphi code has backup in the name. This is because when I wrote the python script, my primary objective was to create a lazy approach to schema updates, but I also included data backup and restore functions (since it made sense to me at the time). The primary function in the Delphi app is backup. The Delphi Form: object fmMySQLBackup: TfmMySQLBackup Left = 444 Top = 164 Width = 436 Height = 332 Caption = 'MySQL Backup' Color = clBtnFac...