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
which means some more time necessary, Not that records are not found at all...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.
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