Indexes not updated when views are open...

[sgauss]

I have a form (vfp6) with a grid based on a view. From the grid I can open one or several other forms that allow updates on the underlying tables including indexed fields. After returning to the view, I have to close the form and re-open it to show the changes. Another affect is that the indexes of the changed tables do not get updated correctly and I must reindex all the affected tables for subsequent forms (based on one to many relationships) to work correctly. <br>

<br>

Any ideas?<br>

<br>

PS. This is using the latest version of the Codemine framework.<br>

 

[foxdev]

Issuing a REQUERY(cViewName) should take care of the first issue.<br>
<br>
I am not familiar with CodeMine, but I cannot imagine an app that corrupts indexes. I assume these are structural indexes, yes?

 

[sgauss]

Yes - it is structural index and I have already tried issueing a requery(). Still does not update the screen. Even issued a refresh() after the requery().<br>
<br>
Thanks

 

[foxdev]

On these forms that are opened from the grid:<br>
<br>
Are they using different data sessions?<br>
<br>
Are the views buffered? If so, are you committing the changes in the forms using TABLEUPDATE()?