Devart Forums

Query->LocateEx("TDateTimeField",TDateTimeValue, TLocateExOptions()<<lxNearest);

finds the nearest matching date but the record it lands on is not centred in the dbgrid.

I'm using 5.90.0.57 for RAD studio 2009.

Hello

When you call the LocateEx function there are two variants of behavior:
1. If a required record is displayed in DBGrid then cursor will change position only, but the record will be not centered in DBGrid.
2. If a required record is not displayed in DBGrid then cursor will change position and the record will be centered.

Hi bork, it works the way you describe for me on string searches but in the date example I posted above the required record is moved to the current grid row when the required record wasn't already showing in the grid.

e.g. if I have a query that contains a single date field with 1 record for every date in 2010, showing in a grid, and the curently selected record is the record with date 1st Jan (row 1 in grid) then

Query->LocateEx("TDateTimeField",TDateTimeValue, TLocateExOptions()<<lxNearest);

with TDateTimeValue set to 1st Aug will move the record with Date = 1st August to the top row of the grid (not centred as it should be).

Thank you for the information. We have reproduced your issue. We will notify you as soon as we have any result.

Hello

We have reproduced this problem and fixed it. This fix will be included in the next MyDAC build.

Thanks bork.