Good morning: My basic question is at what point in time does the SYS_TABLES table and the RX2 file reflect the insertion of data into a table when there is more than one concurrent connection to a given database?
Scenario: 2 concurrent R:BASE sessions connected to the same database In session 1 a program inserts 10 rows into a table. A message is returned stating that 10 rows were inserted into the target table. Switch to session 2 and do a list table on the target table from session 1. The table structure is displayed but indicates 0 current rows. Browse SYS_TABLES for said table and SYS_NUM_ROWS also shows 0 rows. Switching to session 1 and browsing SYS_TABLES shows SYS_NUM_ROWS of 10. Is this due to transaction processing and AUTOCOMMIT being off? Thanks for any guidance and insights. Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
