FetchAll and RecordCount

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
infobyte
Posts: 2
Joined: Fri 08 Mar 2013 01:19

FetchAll and RecordCount

Post by infobyte » Fri 08 Mar 2013 01:22

Hi,

Is there an easy way to get the real "recordcount" value after opening a query, without disable the FetchAll propertie ?

Thanks!

Fabio
Top
AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: FetchAll and RecordCount

Post by AlexP » Mon 11 Mar 2013 10:11

Hello,

To get the total record count you should set the QueryRecCount option to true.
In this case the following SQL statement 'SELECT COUNT(*) FROM ...' will be called automatically.
Top
infobyte
Posts: 2
Joined: Fri 08 Mar 2013 01:19

Re: FetchAll and RecordCount

Post by infobyte » Mon 11 Mar 2013 19:55

Hello Alex,

Ok, thank you.

Fabio
Top
AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: FetchAll and RecordCount

Post by AlexP » Tue 12 Mar 2013 07:55

Hello,

If you have any other questions, feel free to contact us.
Top
Post Reply

Return to “SQLite Data Access Components”