Home zeos and exact record count
Reply: 0

zeos and exact record count

user2175495
1#
user2175495 Published in 2013-04-01 16:37:07Z

D5, Zeos 6 and SQLite

I'd like to know the actual RecordCount of a DataSet.

If it is Filtered then RecordCount only returns the available records as Filtered.

TDbf has an ExactRecordCount which always shows the total Records regardless of Filtering or Indexes.

Does Zeos (or SQLite) have anything like that?

With a Filtered DataSet, I want to use...

Label1.Caption:=IntToStr(tbl1.RecordCount)+' of '+
                IntToStr(tbl1.ExactRecordCount);  // or whatever??

Possible?

If I have to use an SQL Query (Count(*) <-- read about it here) how do I pass the result back to a variable or Function Result in Delphi?

Thanks

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.576415 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO