UniDAC TUniQuery limit 200 records

[pgosierra]

Hello:

I'm using the trial version of UniDAC components. I have Delphi XE4, SQLite database and my project is in Firemonkey for W32.

I'm using a TQuery component to connect to a SQLite table with 450 records. After opening the Query, the RecordCount property says 200. So 250 records are missing.

After looking arround, I found that in the UniQuery Editor, in the Options tab, there is a FetchAll property set to false. I turned it to True and, after that, the RecordCount now shows 450 but after doing a MyQuery.Last the RecNo property is 200 and the grid connected to the query only shows these 200 record.

If I open the UniQuery Editor and click the "Data Editor..." button I see all the 450 records.

Please, tell me what to do to see all the query records in my grid.

I don't know if it is a problem or a limitation on the trial version.

Thank you...

[pgosierra]

Hi:

I found the problem. It's the TLinkGridToDataSource object asociated to the grid.

It needs to have the AutoBufferCount set to TRUE.

After that, everything goes as espected.

Pablo.

[AlexP]

Hello,

Glad to see that you solved the problem. If you have any other questions, feel free to contact us

[Mahmood_M]

Hi
I have the same problem
My DataBase is MySQL, TUniQuery.RecordCount ( with FetchAll = True ) returns correct value but my grid shows only 100 records !
The Grid is a TDBCtrlGrid
What is TLinkGridToDataSource ?! and where I can found AutoBufferCount property ?!
I cant found theme
I`m using UniDAC 6.1.4 and Delphi XE6

thanks ...

[Mahmood_M]

I found it !!, this is a limit on TDBCtrlGrid :

Code: Select all

    procedure TDBCtrlGrid.SetRowCount(Value: Integer);
    begin
      if Value < 1 then Value := 1;
    * if Value > 100 then Value := 100;
      if FRowCount <> Value then
      begin
        FRowCount := Value;
        AdjustSize;
      end;
    end;

I have changed that line to comment, recompiled units and replaced them with VCL units and reinstalled the acDBCtrlGrid and problem solved !

Now, I want to know the reason of this limit ...
Is it a bug and design problem ?!

[AlexP]

This is a standard Delphi component. You should contact Idera (Embarcadero) support concerning bugs in it.