I do not quite understand. I can add a column to the table, and everytime a user (re)SAVE the record, I can update that column with the new date-time. I then have to check the original table every few minutes to see if the date-time column matches with what I have currently in my cursor. Is that right? Then, if not matching, I need to get new updated cursor: REQUERY() does not work with SQL PT cursor,so do I have to do another SQLEXEC to get a new fresh set of cursor?

Thank You!




>Hi,
>
>>As another user updates the original table (myTable), I’d like have all users’ screen to refresh with the new updated value(s). What do I need to change to be able to do so? (example: if user A changes refno from 12 to 146, then I’d like user B to see 146 instead of 12 as user B’s screen refreshes – maybe as he goes to the next record & gets back to it).
>
>there's no automatic way to do this, but you could do it this way: add a timestamp (lastupdate) column to your tables. Then you can write update triggers that store the current date/time in the column when a record was changed. To your application you can then add a timer that checks, if any of the displayed record's timestamp has been changed. If there were changes, you can requery your view or SQL PT command and refresh the display.
>
>Or as an easy solution (if you're displaying single records), you can always load or the record from the database when the user skips through the data. But this will cause more network traffic, so I personally would prefer the first option.
>
>HTH,
>Armin