Re: trick for setting isolation dirty read in an Ace report

In article <protz.2.2EEFA0AF@hookup.net> protz@hookup.net (Mike Protz) writes: >DATABASE sales END >SELECT set_isol_dirty() a FROM systables > WHERE tabid = 1 > INTO TEMP dummy_temp_table; >... I missed the beginning of the thread, but perhaps people have missed the new feature to feed isolation levels via environment variable SACEISOL. You can set SACEISOL to any of: "dirty read" | "committed read" | "cursor stability" | "repeatable read" and the appropriate isolation mode will have effect. This was added for 4.12 and 6.00 and is documented in the online release notes (TOOLREL_4.1 or TOOLREL_6.0), as applicable. SPERISOL has similar effect for sperform. -- Alan Denney aland@informix.com {pyramid|uunet}!infmx!aland "All you of Earth are IDIOTS!" "The greatest labor-saving device of the 20th century? Dan Rostenkowski!" -- Mr. Brain