Re: INFORMIX ACE error

In article <3meo2j$nqv@Venus.mcs.com> dlm@MCS.COM "David Lee Makowsky" writes: > In article <3memil$pn5@mercury.mcs.com>, David Lee Makowsky <dlm@MCS.COM> wrote:> > # Configuration: > > # Online 5.0 > # SQL: 4.11 > # OS: SCO 3.2v4.2 > > # Question: > > # I get an error message which says "long transaction aborted" > # when I run an ACE report with an Online server. The error message > # number is -458. Why does this happen only when I am running a report, > # and not when I am inserting or updating any data? > > Clarification: > > In my last sentence I meant to write "I am not inserting or > updating any data. The only thing I am doing is running an ACE > report. Why is this happening?". > Although ACE doesn't in itself alter the database, it can cause temporary table to be created which are treated as a single transaction. therefore I suspect that the ACE report is creating a vast temporary table for an 'ORDER BY' or join. -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================