Problems with Informix 4.1
Posted in 1993
We have recently upgraded form informix 2.1 to informix 4.1. As a result we are encountering problems which were not present before. We would appreciate any suggestions or inputs in overcoming the same. 1. While compiling a program we encounter the following error "The right margin must be greater than left margin. See error number -4387." The error occurs after the end report sentence. In the program the left margin is set as 0. Needless to mention the same program compiles successfully on Informix 2.1 Problem 2. When a 4gl porgram has a fpreach or a fetch in a while loop and the foreach/fetch returns a status indicating that the row is locked by another user, then the program continues with foreach. However the statement does not result in Informix advancing the cursor to the next row, but instead remaining at that row itself, trying to fetch the locked row again. Only after the locked row is released by the locking agent does the program proceed further to pick up the following rows. In short the informix cursor pointer does not advance to the next row on receiving a continue foreach. As pointed earlier any sugestions, advice hints will be greatly appreciated. ravi