Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
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?