Re: 4GL HANGING PROBLEMS

Jonathan, Are you using any other cursors in your program? You say this effect is random? By that I presume it works for a number of times and then fails. Has it ever failed first time? Are you using Key-Only Select techniques? If not, then I think you should consider it. I would also suggest that you should check the logic to make sure that you don't re-open any of the cursors without closing them. From my experience that has been known to cause problems like this. > > > Situation: > > I am using a cursor declared WITH HOLD to step through a series of > records. I have two other cursors, an update cursor to lock the row and > a normal cursor tpo refresh t he screen details, which are u > sed as I step through the rows. All three cursors are prepared at the > start of the function. > > During operation the user can perform a series of transactions relating > to the screen record which requires the record to be locked first of > all, and then the transactions are committed or rolled bac > k at the end. > > > Problem: > > This works ok for a random number of times until suddenly when rolling > back the system will hang. > You do not get any problems when committing work. > > I am using Informix 4GL 4.10 on SE. Using the output from tbstat it > does not seem to be a locking problem. > > Any ideas anyone????? as this is really starting to be a bit of a pain. Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc