>>I have seen the following problem inconsistently at our sites over the past few years but have now
>> been able to replicate it, but I dont understand why it is happening.
>>
>>Scenario as follows:
>>I have a grid and a command button on a page
>>The Grid shows mostlty records from a Transaction file (TRAN)
>>One of the rows in the grid is: Iif(seek(Cusac,'CUSMF','CUSTAG'),CUSMF.CusName,' ')
>> (This just shows a Customer Name on a Grid using a lookup to a Customer Master File)
>>
>>On the button click event , I have something like:
>>Sele Tran
>>Scan
>> ....
>> && AAAA
>> Seek Tran.Cusac
>> If not eof()
>> Do stuff on the CUSMF
>> Endif
>> Sele Tran
>>Endscan
>>
>>Now most times, this works fine.
Hi Fabio.
Just to let you know... I checked out setting the Refresh but this did not have any effect
From the documentation, the Set refresh seems to affect Browse command (and not Grids)
I have gone with either having a different alias, or hiding the grid, depending on my form.

Regards,
Gerard



>>When there are lots of Transation records, say 100 or more, the wrong CUSMF record is seeked (In AAAA)
>>If there are say 900 records, the wrong CUSMF record could be processed wrongly 4 times
>>If I run the same code again, wrong records are processed, but different wrong records
>>
>>The 'ACTUAL' record that is incorrectly 'Seeked' turns out to be the Last record that is visible on the Grid
>>This is always the case.
>>What appears to be happening, randomly, is that in the middle of the Scan Loop (which is on the Click event of a Button)
>> Foxpro is going back to the screen somwhow, running the IIF on the grid, landing on a different record and then processing
>> thsi record on the CUSMF instead of the SEEKED record. I think the SEEK is actually working but in the middle of the loop
>> the IIF is also kicking in and landing on the wrong record.
>>
>>As far as I can tell, I dont have any code that refreshes, or sets focus back to the form, I dont have any set realtions on either
>>
>>Now that I have been able to replicate this, it expalins about 4 other intances in Forms where data has been updating the wrong account, on other tables
>>
>>I have been able to code around it by either making the Grid Invisible (just prior to calling the code) or taking the IIF out of the Grid
>>
>>Would anybody have an explanation for this type of behaviour ?
>>TIA,
>>Gerard
>
>check
>SET REFRESH TO