RE: [DUG]: TDataset - Recordcount

[James Low]

Thanks - figured there must be something. -----Original Message----- From: Guy Brown [mailto:[EMAIL PROTECTED]] Sent: 24 August 2001 08:49 To: Multiple recipients of list delphi Subject: RE: [DUG]: TDataset - Recordcount There is a TDataSet.IsEmpty method.   Guy -----Original Message----- From: James Low [mailto:[EMAIL PROTECTED]] Sent: Friday, 24 August, 2001 8:45 a.m. To: Multiple recipients of list delphi Subject: [DUG]: TDataset - Recordcount If I have a TQuery with a select statement like 'Select ID from myTable where ID = 1' am I correct in assuming that the best way to verify that there is a record (or more than 1) with ID = 1 is to test the Recordcount property?   The reason I ask is that if all I am interested in is the fact that there are more than 0 records then the Recordcount method seems overkill (as at some point the entire recordset is navigated which in the case of a large recordset is time consuming).   ...I guess I can override recordcount or implement my own method but before I do this thought I should double check.   Thanks