jdg

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.