liteTable.FetchAll

Discussion of open issues, suggestions and bugs regarding LiteDAC (SQLite Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Mark2018
Posts: 8
Joined: Sat 04 Aug 2018 20:03

liteTable.FetchAll

Post by Mark2018 » Mon 26 Nov 2018 15:06

Hello,
I have an odd behaviour in TliteTable;
working with two TLiteTables on the same DB table, adding few records useing the first TliteTable1 and committing,
if I open the 2nd TLiteTable2 I cannot LOCATE the records just added...
It seems due to FetchAll=False on second table.
But the manual says that
When the FetchAll property is False, the first call to TMemDataSet.Locate and TMemDataSet.LocateEx methods may take a lot of time to retrieve additional records to the client side.
which means some more time necessary, Not that records are not found at all...
With FetchAll=False also the TLiteTable2 .RecordCount result wrong (without records just added and committed).
Of course everything is correct (Locate, RecCount) working on TLiteTable1 only.
What is the right interpretation of FetchAll together with RecordCount ?

Regards

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: liteTable.FetchAll

Post by MaximG » Thu 29 Nov 2018 12:04

We tested the operation of our product according to your description and found no problems. Please describe the behavior you are interested in in more detail. Perhaps you can compose and send us a small sample clearly demonstrating the issue. For your convenience, please use the e-support form (https://www.devart.com/company/contactform.html).
To get the number of records when using the FetchAll=False property, use the QueryRecCount option:
https://www.devart.com/litedac/docs/dev ... ccount.htm

Post Reply