dbgrid scrollbars

[lordoza]

Hi,
im developing some database app under win32 which use dbGrid to show some data , when i load data to dbGrid from SQLQuery vertical scroll bar is always the same and it is "calculated" after scrolling down its very annoying.
It is normal ?
im using latest snapshot.

[Kknd]

Im using the latest snapshot too, but i dont have this problem. But im using a SQLite db. Win 32 too.

[jesusr]

Hi,
im developing some database app under win32 which use dbGrid to show some data , when i load data to dbGrid from SQLQuery vertical scroll bar is always the same and it is "calculated" after scrolling down its very annoying.
It is normal ?
im using latest snapshot.

This is the normal behaviour, the grid doesn't retrieve all records when you open the dataset, it only retrieve the needed visual records.

Some dataset implementatios do retrieve all records as Tdbf and it seems sqlite also.

For SqlQuery you can fetch all records when you open the dataset by setting PacketRecords property to -1 in object inspector or if you want to do it in code and your dataset is ds then:

Code: [Select]


ds.PacketRecords:=-1;
ds.Open;


[lordoza]

it works like a charm! thanks jesusr!
and... i have another question about dbgrid scrollbars is it posible to refresh view (records) when scrolling?

thanks!

[Marc]

Fetching all records is fine for small datasets, but be carefull when a query might return 1mil records.

Side note, some db implementations return the number of records a query will return, without fetching all records.