DBAdvGrid empty line on empty recordset

VCL TMS VCL UI Pack
1

Is it possible to avoid to have an empty line in the dbgrid when there isn't any record in the dataset ?

2

Did you try to set
grid.FixedRowAlways = true?

3

I tried both True and False but there is always an empty row when the recordset has zero records

I also tried putting FixedRows=0 but the change is ignored it comes back to 1.
4

I overlooked the (public) property grid.ShowBlankRow needs to be set to false.

5

I tried it, but it doesn't seems to work, there is always an empty row displayed.

6

Are you doing these settings BEFORE you activate the dataset?

7

Yes.

How can I upload a little sample ?
8

To contact support directly: https://www.tmssoftware.com/site/support_mail.asp


We have retested this here using the ADOQuery demo where this setting was added in the form constructor and when using a query returning zero records, except the fixed column header row, no rows are visible in the grid.
9

Hi,

I'm interested in the finality of this discussion.
10

In FormCreate


procedure TForm1.FormCreate(Sender: TObject);

begin

  DBGrid.ShowBlankRow:=false;

  DBGrid.FixedRowAlways:=true;

  DBGrid.FixedRows:=1;

end;


but it works just when the dataset is active, the limitation is for the inheritance from the standard string grid.


11

Thanks,


I will try to make it work on my end, but that's a sad limitation :(