Tom

See my response to Vlad. It seems I needed an FLOCK(), UNLOCK then SYS(1104) from BOTH sides, the creater of the record and the query.

Kev

>>>>I've tried the various suggestions I've had and I find that sometimes it takes around 30 seconds to pick up the changes!
>>>>
>>>>In my application (where the problem is occurring) it's a form with Optimistic Buffering and in a Private Datasession.
>>>>
>>>>In my development environment, where I'm changing the table there is no buffering.
>>>>
>>>>Now I can't understand why it sometimes takes 30 seconds and sometimes 5 seconds to pick up the changes.
>>>>
>>>>????
>>>>Kev
>>>
>>>Have you tried turning off buffering in the problem application ?
>>
>>I really need buffering on.
>>
>>>I'm still not sure which side the problem lies on - the development environment not getting the data written or the application using old buffered data.
>>
>>>Did you try setting the refresh time on both the app & dev. env. ?
>>
>>Yes, I set it to 1 on both.
>>
>>There is another funny problem. In the Init of the form it calls UpdateOrder and when changing the optiongroup it calls updateorder.
>>
>>But when loading the form, the initial call from the Init method seems to be ignored (it is being called) and I have to click on the optiongroup to force it?!!!
>>
>>Kev
>
>Kev;
>
>When the main problem sorts itself out try moving your code from the Forms Init to the Activate.
>
>Tom