TUniDBGrid has two error, What are wrong?

[Freeman35]

Hello,

Delphi tokyo, unigui 1399, firedac firebird.

1- When open query, shows only 2 pages on TUniDBGrid. Just put TUniDBGrid on form and just add colums. After form show, for test query close then open, just show 2 pages. Problem is query has a 5 pages.

If I run this code, grid show normally, I mean show 5 pages.

     R:= Q_.FieldByName('ID').AsInteger;
     Q_.Close;
     Q_.Open();
     try
       Q_.DisableControls;
       Q_.Locate('ID', R, []);
     finally
       if Q_.ControlsDisabled then Q_.EnableControls;
     end;

2- Scroll bars has a painting problem. There is no css code or no any js code added. wrote on top of message, just put TUniDBGrid and added colums. Scrool bars always not painting or that's color is black.

Thank you.

 

[Sherzod]

1- When open query, shows only 2 pages on TUniDBGrid.

Hi,

 

UniDBGrid > WebOptions > FetchAll = True

[Freeman35]

Hi,

 

UniDBGrid > WebOptions > FetchAll = True

Hello,

Is this mean, Fetch All records from server to client? if Is yes this is not good solution for me 'cos table can be huge.

I reminded this

http://forums.unigui.com/index.php?/topic/7150-tunidbgrid-pagingbar-da-nextpage-pasif-durumu/

procedure TFRM.GRD_RecordCount(Sender: TUniDBGrid; var RecCount: Integer);

Questions:

1- Is this event, better then UniDBGrid > WebOptions > FetchAll = True ?

2- Query.Locate is trigger FetchAll for uniDBGrid?

Best regards

[Sherzod]

Is this mean, Fetch All records from server to client?

 

No, count specified in pageSize

[Freeman35]

Thank you for answer.

I used and it worked for me.

UniDBGrid > WebOptions > FetchAll = True

Thank you.

 

Have you idea for scroll bars color?

Regards.