Can't see changes after UPDATE

["Pascal Bellerose" <midrange_list@xxxxxxxxxxxx>]

Hi,

Here's my problem:

An interactive program named "Bill" runs on a server.   "Bill" updates
records to file "table1" and adds records to file "table2".
"Bill" has started last night and won't stop until I tell him to do so.  If
I try to lookup for changes since "Bill" has started I can't see them with
SQL.  If I stop "Bill" then I can see the records added and the ones
updated.

Can someone tell why is it like this and how can I work this around?  I
thought of creating seperate programs for UPDATE and WRITE operations, but I
thought maybe there was an easier way of doing it.

thanks,