Number of Items in a Table

[tjc240e]

Would the best way to find how many items there are in a table be just go through with a while do loop or is there an easier way?

TIA

 

[Zathras]

What kind of table?

Database: SELECT COUNT(*) FROM ATABLE

TStringGrid: MyGrid.RowCount - MyGrid.FixedRows

TDBGrid: There is a property, but accessing it may cause all of the records to be read, hurting performance. May be best to use the SELECT COUNT(*) technique.

 

[tjc240e]

It is a TCBTableSet...

 

[Zathras]

Sorry, not familiar with that. But if it descends from TDataSet, there should be a .RecordCount property.

If you experience performance problems, try experimenting with client-side vs server-side result sets.

using a TQuery with SELECT COUNT(*) should work in any case.

 

[jbpelletier]

if the table is already loaded in a Ttable..

u could also use

Table1.RecordCount

jb