QUERY TOOL

File Size: 423 KB

Download Query Tool:

I wrote Query Tool since I could not find a single tool that would be useful to implement both simple and complex SQLs with a common easy to use environment. This tool can be used by someone beginning to experiment with SQLs to someone who has to run more than a 100 SQLs a day to get their job done. In order to use this tool, you will have to have Borland Database Engine (BDE) pre-installed in your computer. BDE comes with Borland Delphi and it should be in your computer if you have Delphi installed. BDE is also a freeware and can be obtained from anyone having it. If you need BDE, visit Borland's Web Site at www.inprise.com, copy it from your friends or contact me by email at rajeshwer@usa.net and we will figure out a way to get it to you. Here are some of the salient features of this tool:

• Can handle any database desktop or remote as long as an alias is created for the database in the Borland Database Engine.
• Can be used to SELECT, INSERT and UPDATE among other things.
• The desktop or the SQL entering area is totally customizable (including fonts, color of the background etc.).
• Functions like saving, retrieving and printing a SQL are provided
• The program "remembers" the directories visited, username provided, alias used etc.
• The result is presented in the form of a grid for select statements
• The result grid is totally customizable. It can be sorted, column names can be changed, column widths can be changed and searched for a particular value.
• The program "remembers" the sort order, column widths and new column names of the result grid.
• The result grid can be printed. Printing also has lots of options.
• The time taken to execute the query is also shown.

DELPHI TUTORIALS

File Size: 109 KB

Download Delphi Tutorials:

Welcome to this four part series on Delphi Programming Fundamentals. These tutorials are meant to make the audience familiar with Windows programming using an application development tool called Delphi, a product of Borland (now called Inprise). The subject matter in the manuals are organized in a manner different from what you would normally expect. The reason for that is twofold: I felt that it is important that these manuals be as interesting as they are informative. Secondly, there are hundreds, if not more, of books and manuals on Delphi that the users can pick up and learn the usual programming techniques. The subject matter taught in these tutorials are intended not only to make the audience familiar with Delphi programming but also to prepare them for their first Delphi job.
These tutorials are organized in the following manner: Each chapter begins with an introduction to a specific topic in Delphi. Unless it is absolutely necessary, no more of a certain topic will be taught than is deemed essential for the readers to understand the accompanying example program. Thus the goal for each chapter is to make the readers totally familiar with the accompanying example program. At the end of each manual, there will be a few programs that will be left as a exercise for the readers. The readers are urged to make every effort to get these programs done before they go on with the other tutorials. After completing all four tutorials, the readers are urged to take the exam provided as part of this tutorial.
If there are questions or suggestions, please address them to: rajeshwer@usa.net