QueryRecCount and vertical scrollbar

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Marcello

QueryRecCount and vertical scrollbar

Post by Marcello » Wed 20 Apr 2005 12:42

I use two tMSquery to show a master-detail relationship on a form with two dbgrids.
The tMSQuery component has these properties

FetchAll=False
FetchRows=100

Why with Options.QueryRecCount:=True the detail grid doesn't show the vertical scrollbar.

Why?
Is there some settings I must change to prevent this behaviour?
Someone else has seen some like this?
With QueryRecCount:=True the dataset should knows the right number of
records and the grid should shows the updated vertical scroll bar

Thanks
Marcello

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Wed 20 Apr 2005 14:58

We couldn't reproduce the problem.
Please send us (sdac*crlab*com) complete small sample to demonstrate it and include script to create server objects.

Also please supply us following information.

- Exact version of Delphi or C++ Builder
- Exact version of SDAC. You can see it in About sheet of TMSConnection Editor
- Exact version of Microsoft SQL Server and OLE DB provider that you use.
You can see it in Info sheet of TMSConnection Editor

Marcello

Post by Marcello » Wed 20 Apr 2005 16:22

Did you try with many records??
If in the detail table there are few records (<FetchRows??) the scroll bar appears.
I will send a little project and the script you requested..
Thanks


Ikar wrote:We couldn't reproduce the problem.
Please send us (sdac*crlab*com) complete small sample to demonstrate it and include script to create server objects.

Also please supply us following information.

- Exact version of Delphi or C++ Builder
- Exact version of SDAC. You can see it in About sheet of TMSConnection Editor
- Exact version of Microsoft SQL Server and OLE DB provider that you use.
You can see it in Info sheet of TMSConnection Editor

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Thu 21 Apr 2005 07:14

> Did you try with many records??

Yes

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Thu 21 Apr 2005 14:01

Thank you for your sample. It does help us very much. We reproduced your problem and fixed it. This fix will be included in the next SDAC build (3.50.0.14 and 2.45.2.29). It will be available in about two weeks.

Post Reply