I actually put it in the Save method of the business class. I'm going to play a little bit more, but seems like it does no effect.
May be there is something else, I'm investigating...
>Do you try it in FIRST form?
>
>>Don't seem to make a difference :(
>>
>>>Try sys(1104) or FLUSH FORCE
>>>
>>>>Hi everybody,
>>>>
>>>>I'm running into the problem, where Select SQL doesn't see updates.
>>>>
>>>>Here is the scenario:
>>>>
>>>>One form with private DS calls another very complex form with private DS. The user makes changes on the second form. As long as changes saved, the first form should be refreshed. Originally I was using views and everything worked. I switched to using direct select sql commands and now my data are not refreshed properly. However, then I close the first form (the whole application) and re-start it, I see data refreshed.
>>>>
>>>>What can I do to rectify the problem? We're going to switch to VFP9 in few days, but presently we're working with VFP8.
>>>>
>>>>Thanks in advance.
If it's not broken, fix it until it is.
My Blog