Shead Programming
Shead Programming
Previous Projects
This covers only part of the period 1999-2000.
| ODBC Class Library | The ODBC class library is designed to keep track of connections made, statements created, etc., and to help ensure that what is done is undone properly to make the ODBC drivers happy. It handles prepared statements, bound parameters, multi-row rowsets, cursors, etc. Its features include: (1) a ResultCol class that automatically allocates a buffer and does an SQLBindCol() correctly; (2) a Statement class that creates the set of ResultCols needed for a query; (3) the ODBCSeekTable class, which allows one to seek to a particular row in a table using a cursor and a prepared statement. You can then use the cursor functions Statement::UpdateRow(), Statement::AddRow(), Statement::DeleteRow(), etc. The Statement class is very close to the API, so that you can do whatever you want with it. The library can be used with or without the VCL. | |
| Transaction Processing | The ODBC class library was designed to translate a multithreaded program for a client from the use of the CodeBase™ class library on FoxPro® tables to the use of the ODBC system on an SQL Server database. In the process, I gained experience with transaction processing, with multithreaded design, and with Client/Server design and setup. SQL Server was set up on a server running Windows NT, and I programmed on the client, running Windows 95. | |
| A Custom Database Editor | ZEdit, a Windows multi-user database program to aid companies to work more conveniently with the data that goes into remote transaction terminals. My client wrote the library that works with the terminals, and I added the editor to it. It also successfully imports data from an ill-defined industry standard file format. Lately, it has been updated to include an editor for .tdf files. | |
| A DLL | I wrote a DLL to calculate and append a CRC word to a byte array. My client provided the CRC calculation code. The function was exported for a Visual Basic® programmer. | |
| A Customized Installation Program | A Setup program that allows users to modify a collection of registry settings for a variable collection of objects (in this case, Com ports), and to use the setup program multiple times to modify the registry settings, without reinstalling the files. | |
| JString® | A string class designed for speed and convenience. JString's interface is modeled after std::basic_string. It was designed to solve a speed problem when streaming file data into a string, or a container of strings, one character at a time. | |