PROBLEM WITH REFRESH IN GRID 1

[JAVIERSA]

sometime a grid dont's show correct data.<br>
<br>
this is the case.<br>
I have relation one to many.<br>
and I use a boton to add a new record in the grid.<br>
sometime when I add new record dont'n is showed in the grid<br>
other sitation, if I change master record dont'n refresh the grid once eject THISFORM.REFRESH.<br>
<br>
if move scroll bar in grid the record appear.<br>
<br>
or stop the form and select with CLICK (MOUSE) the same table that is selected in datassesion screen and return to form, records appear (relation work fine)<br>
<br>
I tried; select master table and eject GO record number to force relation, refresh the form, select child table. and dont'n refresh, this intents is running the form.<br>
<br>
only when I stop the form a do something interative work fine.<br>
<br>
somebody can tell me something. tanks<br>
<br>
note: this situation occur sometime (sometime work fine other not)

 

[jvillanueva]

I used to run into the same problem, a simple work around that I did is after updating the record, I re-load the recordsouce property of the grid and then set the refresh property. It works for me.<br>
Good luck.<br>
<br>
Jun<br>

 

[foxdev]

This probably sounds hokey, but there have been times that the only way to solve a similar problem was invoking the grid's DoScroll method, as in:<br>
<br>
grdGridName.DoScroll(2) && simulates PgUp<br>
<br>
Grids can be frustrating, eh?<br>
<br>
---------------<br>
Raza<br>

 

[LordOfCode]

It used to happen to me often. So I'd rather to use parameterized views. And then set the grid RecordSource property to the Parametrized View. <br>
It has never failed to me.<br>
<br>
For example if you want to now all the clients in determinaded zone. Fill a combobox with all the posible different zones. And link the grid to a local or remote view like this.<br>
<br>
<br>
Create View MyView As;<br>
Select * from Order Where Zone = ?cZone<br>
<br>
Where ?cZone is a parameter determined by the zone you selected in the combobox.<br>
<br>
<br>
<p>Edwin Dalorzo<br><a href=mailto:edalorzo@hotmail.com>edalorzo@hotmail.com</a><br><a href= > </a><br>