Hello, I have a weird problem with a grid on a locate screen that I have never noticed before.
I have a maintenance screen with a locate button, that opens a modal search form with a grid to select a record.
When I load the grid with several hundred records the first time it loads fine at the top of the file.
The user selects a record and I return to the maintenance form and show the record details.
If the user clicks the locate button again, I load the search form with the grid and position the cursor to the record that was previous selected and the grid shows the correct record.
The problem is when the user clicks on the grid, it repositions itself to the first page of the grid and now we are on the wrong record.
Very weird ... Has anyone seen this behavior and possible solution ?
Thanks, Kent
Sounds like you have code running somewhere that you don't expect. Have you set a breakpoint to track when the record pointer moves in the grid's recordsource?
Frank.
Frank Cazabon
On 16/11/2018 12:49 PM, Kent Belan wrote:
Hello, I have a weird problem with a grid on a locate screen that I have never noticed before.
I have a maintenance screen with a locate button, that opens a modal search form with a grid to select a record.
When I load the grid with several hundred records the first time it loads fine at the top of the file.
The user selects a record and I return to the maintenance form and show the record details.
If the user clicks the locate button again, I load the search form with the grid and position the cursor to the record that was previous selected and the grid shows the correct record.
The problem is when the user clicks on the grid, it repositions itself to the first page of the grid and now we are on the wrong record.
Very weird ... Has anyone seen this behavior and possible solution ?
Thanks, Kent
[excessive quoting removed by server]
I have a similar problem, this time with a checbox in a column of the grid. When the user clicks on the checkbox, it performs some code in its click event and then, instead of staying on that record, the pointer goes up to the top of the grid. This is annoying.
Finally I solved it with this code in the click event of the checkbox: local nRec nRec = recno('mycursor')
** perform some code here
select mycursor locate for recno() = nRec this.parent.parent,refresh
In my case, the pointer stays on the record it is supposed to be.
Hope it helps
Rafael Copquin
El vie., 16 nov. 2018 a las 13:49, Kent Belan (kbelan@mchsi.com) escribió:
Hello, I have a weird problem with a grid on a locate screen that I have never noticed before.
I have a maintenance screen with a locate button, that opens a modal search form with a grid to select a record.
When I load the grid with several hundred records the first time it loads fine at the top of the file.
The user selects a record and I return to the maintenance form and show the record details.
If the user clicks the locate button again, I load the search form with the grid and position the cursor to the record that was previous selected and the grid shows the correct record.
The problem is when the user clicks on the grid, it repositions itself to the first page of the grid and now we are on the wrong record.
Very weird ... Has anyone seen this behavior and possible solution ?
Thanks, Kent
[excessive quoting removed by server]
These wikis might help? http://fox.wikis.com/wc.dll?Fox~DisplayFindResults
I barely remember that there were tricks in using grid:
1. this.recordsource=this.recordsource
2. select (this.recordsource) go recno() this.refresh()
I still think there were some codes in your popup screen that moved the record pointer of the grid's recordsource. You could re-open the grid's data source using aliases without moving the record pointer in the grid.
* something like these: select 0 use (grid.recordsource) again noupdate alias haha * do your stuffs use in haha
On Sat, Nov 17, 2018 at 12:50 AM Kent Belan kbelan@mchsi.com wrote:
Hello, I have a weird problem with a grid on a locate screen that I have never noticed before.
I have a maintenance screen with a locate button, that opens a modal search form with a grid to select a record.
When I load the grid with several hundred records the first time it loads fine at the top of the file.
The user selects a record and I return to the maintenance form and show the record details.
If the user clicks the locate button again, I load the search form with the grid and position the cursor to the record that was previous selected and the grid shows the correct record.
The problem is when the user clicks on the grid, it repositions itself to the first page of the grid and now we are on the wrong record.
Very weird ... Has anyone seen this behavior and possible solution ?
Thanks, Kent
[excessive quoting removed by server]
-
Frank Cazabon -
Kent Belan -
Man-wai Chang -
Rafael Copquin