I agree with Jim. If you want to use FLUSH use it after End transaction. Now, the problem could be if you use nested transactions (as in MereMortals framework parent-child biz objects). In this case you would need FLUSH only in the top most object. That's why I abandoned the idea of using FLUSH at all.

Also it doesn't seem to be an issue for you, but we were bitten bitterly because I didn't specify the alias in the FLUSH command. All save operations were slowed considerably and because of this my mistake we had to hold off transition to VFP9 for several weeks...


>OK, my company are now moving all out existing codebase (VFP7) over to VFP9, so it seems pertinent that I revisit some of the code I use.
>
>I have trawled the UT, and Googled, reading many articles and comments about these commands, but there does not seem to be any 'real world' examples of where/how they should best be used.
>
>For example, consider a wrapper function around the TableUpdate function.
>
>

>Function MyTableUpdate (tvRows, tcAliasOrArea, taErrors)
>TableUpdate( tvRows, tcAliasOrArea, "taErrors")
>

>
>Would it be reasonable to add:
>

>Flush In (tcAliasOrArea) Force
>

>if one wished to confirm data is written to the drive as quickly as possible?
>(Assume an almost realtime networked system where another using is waiting for the data to be updated)
>
>
>What issues arise from having the data buffered? What if MyTableUpdate is called within a transaction?
>
>For the user waiting for the response, should the lookup routine make use of Sys(1104) ?
>
>Where do you guys & gals use these commands? Samples greatly appreciated
>
>
>Regards
>
>
>Malc