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
- KDE vs. Trinity: Is One Really Better?
- Linux Mint chief not carried away by success
- Almost openSUSE 12.1
- Unix and Linux: a bit of history
- Learning from GNOME
- Has Linux dropped off the face of the Earth?
- Barnes & Noble Exposes Microsoft’s “Trivial” Patents and Strategy Against Android
- GPL upheld in Berlin case
- Install LinuxMint12 extensions Mate & MGSE in Ubuntu 11.10
- Fedora 16 GPT disk partitioning guide
- Small tech companies, big wins
- Ardour: An Audio Editor That’s Hard to Master and Tough to Beat