Devart Forums

Hi,

I've been trying out the new SQLite provider, and it seems to work just fine

One little question though, when having FetchAll property set to False and I open a table in TDBGrid I get total number of records 25, instead of showing the real recordcount. I don't see this problem when using MySQL, so it seems to be related to SQLite.

Regards

Peter

All providers have such behaviour. You can set the QueryRecCount option of TUniQuery to True. In this case the component queries the actual record count on Open.

Ok, then there must a problem with the other providers They do show the real record count when opening a table. I'm using the exact same TUniConnection, I just change the provider and login/pass/server. For MS SQL, MySQL and PostgreSQL it shows the real count. For SQLite it shows 25.

I simply open a table in a grid.

/Peter

SQL Server, MySQL, and PostgreSQL providers have FetchAll = True by default. So they show the real record count.

SQLite, Oracle, and InterBase providers have FetchAll = False by default. So that you should change it to True, or set the QueryRecCount option to True.

How to get next 25 Records?

The next block of records is fetched automatically when you move to a record that was not fetched yet.