Jump to content

jdg

Members
  • Content Count

    1
  • Joined

  • Last visited

Everything posted by jdg

  1. jdg

    Database in Delphi

    Good morning Praxis. My first post here so go easy on me please. I have recently upgraded from Delphi 4 to Delphi 10.4 - yes, a big leap indeed. My previous database experience is with the BDE, so sadly now my knowledge has become obsolete. I'm struggling to learn a new way. Good code examples are proving difficult to find on line. At this time I'm primarily interested in local client data interface. Firstly - I would appreciate any recommendations on books that do a good job explaining how to use the database components in 10.4 please. Secondly - what are your preferred database components? I've been experimenting with IB components. Also, I'm getting some unexpected results from this simple exercise & can't figure out what's wrong. Any help is appreciated. I have IBConsole and have created an experimental database and some tables to use while feeling out coding with some TIBTable components. I have a table of projects & a table of people & I'm wanting to create a relationship between projects in people in a third table. As it stands now I'm only working with the first two tables, so disregard the table that holds the relationships. In a data module I have a TIBDatabase & a TIBTransaction component, with two TIBTable & two TDataSource components. I'm trying to read through the records in one of the tables & it's simply not working. My contacts table has four records in it. This code: tblConts.open; ShowMessage('tblConts Record count: ' + IntToStr(tblConts.RecordCount)); Shows a message that says I have one record. I don't understand why I'm getting this incorrect result. It should be four. Also this code fails, never finding the first record. I've tried it with the table filtered & unfiltered. if tblConts.FindFirst then repeat ... until not tblConts.FindNext; Any ideas? Thanks in advance for any help.
×