>I am using buffermodeoverride of 5 in a table that I want to make temporary updates unitl a tableupdate command is issued. Prior to the tableupdate command I want to be able to query the table and include the pending records. I have not been successfull in doing so. Any suggestions?

SQL Select won't work because this opens the tables/views again in another work area. You have to use commands that work on the current alias: LOCATE FOR or SCAN FOR ... ENDSCAN.