I am developing a database application using D6 and MySQL. In designing my reports I tried using the SQLTable/SQLQuery datasets directly with little success. When I use the ClientDataset everything works alright except for the preview in design mode which behaves unpredictably. It displays only one record even though the underlying table has many records. At runtime the same report displays the relevant records from the SQLTable/Query.
I would like to know if the approach I am using is the right one. Any related material would also be of great help. Something else that baffles me is Calculated fields in the ClientDataset. I have created my own calculated fields and coded them in an OnCalcFields event which works great. Are there any other methods for using calculated fields in a unidirectional database apart from the traditional methods I have been using with for example paradox tables?