>1) Yes, the FLUSH command can be written in a program.

No, what I mean, is that usually FLUSH will write the data to the disk for the current data which has not been flushed from the current application. In this case, an application which does not do any data processing can't read the updated data that I manually did from a command prompt.

>2) I remember you had REPROCESS set in another of your programs. Do you also have a value set for REFRESH? If so, then it is possible that the time you have specified has not expired. Set it lower to see if you have a change in behaviour.

No, I don't have a value set for REFRESH.

Thanks, I'll look forward for the FLUSH command help and see what is related to that.