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.
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
until not tblConts.FindNext;
Thanks in advance for any help.