Re: Error -255 ... why?

In article <4lin63$g96@loki.tor.hookup.net>, Rajendra_Singh@msn.com (Rajendra Singh) wrote: > I have an application which I developed on an HP 700 running HP/UX > v9.07 and ESQL/C v6.0. The application uses an update cursor to > update a record. It works fine, BUT when I recompile the application > on an 800 series HP/UX v9.04 machine and run it, I get an error -255 > when I attempt to open the SELECT cursor. Why is this? > > By the way, both machines are running SE. Logging is disabled on the > 700 and enabled on the 800. > > Any help would be greatly appreciated. > > Thanks. > --- > Rajendra Singh, B. Sc. (Rajendra_Singh@msn.com) > "What is understood need not be discussed." - Loren Adams > Curiously enough, I ran into exactly the same problem today. The solution: The update cursor has to be opened and used inside a transaction, or you have to declare it WITH HOLD to span transactions. Hope this helps. -- Oyvind. (oyvindpe@sn.no)