Skip to content

GitLab Next

Closed
Created by FPC Admin account@fpc_adminOwner

Scrolling throw db records in DBGrid, with arrow keys, in Qt widgetset, skips the last record.

Original Reporter info from Mantis: zoran
  • Reporter name: Zoran Vučenović

Description:

When you scroll in DBGrid with up and down keys, the last record is skipped in Qt widgetset. The bug does not occur in Win or Gtk2 ws.

Additional information:

I'm uploading the simple application which shows the bug. The application connects to a database named "db_test", change the path as appropriate for you. I use Firebird, but if you don't have FB installed, please make changes in the application to connect to dbms of your choice. You need to create the following table:

create table countries (
  id integer primary key,
  name varchar(30)
);

insert into countries (id, name) values (1, 'Italy');
insert into countries (id, name) values (2, 'Belgium');
insert into countries (id, name) values (3, 'Russia');
insert into countries (id, name) values (4, 'Spain');

The application connects to this table and shows four rows in grid. To reproduce the bug, press down key three times and see that the last row gets skipped and the grid appends new row.

The bug cannot be reproduced with read-only dataset or grid, so take care that Query and Grid have ReadOnly set to False (which is the default).

In my example I use SqlDB components, but I tried with Zeos also and the bug remains! Therefore, this is probably Qt widgetset bug, not SqlDB bug.

Mantis conversion info:

  • Mantis ID: 22187
  • Version: 1.1 (SVN)
  • Fixed in revision: 37534 (#64f7c37c)
  • Target version: 1.0