Wednesday, 16 November, 2011

Yesterday I finished the game lineup dialog for the soccer program. This was the one I had to think about overnight, and it required another database table. Using the new table was easy; populating it turned out to be a bit harder than I anticipated.

The soccer program uses a database that is implemented as a Windows DLL by one party. The interface from Delphi to that database is some components written by yet another party. All the interfaces are there, but they don’t always work the way they should, or at all.

For instance, I should be able to delete all records from a table with a simple SQL statement: “DELETE FROM tablename”, then run that statement with ExecSQL. It turns out that the ExecSQL method may be there, but it doesn’t seem to work. So I have to “SELECT * FROM tablename” then run through the result set, one record at a time and use the Delete method, which does work.

The latest problem was populating the new table, which is identical in layout to an old table. I should have been able to run through the old table and use the AppendRecord method to add the old fields to the new table. Of course, that didn’t work. I had to use the Append and Post methods instead. Frustration abounds – my next project will not be in Windows.


I watched the very last Harry Potter movie last night. It came in the mail from Amazon and I now have all those movies. I never had the time to watch the film when it was out in the theaters, so I’m glad I could do that now. It’s a much better movie than part 1. The whole thing is resolved fairly closely to how the books were written.


Silly sign of the day:


Free/Open Source Software