Board index » delphi » Use of the recordcount method in ADODataSet?
Bob Dalton
Delphi Developer |
Use of the recordcount method in ADODataSet?2004-08-06 03:54:57 AM delphi252 Is using the recordcount method in ADODataSet the preferred method for getting a count of the records that have been returned from the commandtext statement in situations where you need a record count? I remember that using this was discouraged and not recommended for BDE and other database systems because it wasn't acurate and it placed a large processing burden on the database server. Still rather new to ADO so not sure how this works compared to other non-SQL database systems. BTW I am familiar with the 'select count *' SQL command but not how to use it in conjunction with a ADODataset that needs to also feed a database display grid (an example). Also how do you get the results from a 'select count *' statement for use as a variable in your program? An example of my commandtext statement without count: select * from Personnel order by PERS_USERID Regards; Bob Dalton |