>Hi All,
>
>We have an intermittent problem when updating data using the REPLACE command on two tables on the first machine. The data is saved but is not updated when looking at the data on the second machine until the application is closed on the first.
>
>We then tried specifying UNLOCK ALL after the REPLACE commands but the problem just evolved to either one of the table's data being displayed on the second pc correctly.
>
>I need to mention that the data was being viewed on the second pc using the BROWSE command after each REPLACE command on the first pc. We do not use buffering, transactions or multilocks on the tables. And the REPLACE is executed on a single record, locating by using SEEK, and using an UPDATE statement executes very slowly as the size of the tables get quite large.
>
>Any help will be greatly appreciated.
>
>Thanks,
>Jeun
Jeun,
I see changes immediately. Probably your browse needs refresh (see set refresh). Also you might try:
select * from myTable
after each replace on first computer.
Cetin