Re: Move from 5.01 to 7.21 4gl problem

We've had a similar problem when enhancing a 4gl under v6tools/v7 engine. Unfortunately, my experience may not help you. In our case, we had a multi-purpose report 4gl which had a variety of possible select statements as candidates for the report driver. The report driver would PREPARE the select statement, DECLARE the cursor and OPEN the cursor using a set of variables the number of which depended on the select statement being used. When we enhanced (added a new select statement to the possibilities), this particular statement consistently reported error 254. If we had a regular DECLARE and FOREACH, things worked OK. I hate to admit that we didn't dig deep enough to reach any clear conclusion about the source of the problem - we just plumped for the DECLARE-FOREACH method after about 2 hours of this and that. Suggestion : Replace "OPEN tmp_cursor" with a FOREACH loop. P.S. If you do reach a definitive conclusion about this problem, please post it (let me know, at the least). In article <5n7gjq$5v9@cssun.mathcs.emory.edu>, dhinkle@firstam.com ("David J. Hinkle") wrote: >Howdy, > >We are in the middle of a move from the Informix 5.01 engine to the >Informix 7.21.UD1 engine. We have a mamoth 4gl application that >needs to survive the move. Note that the 4gl application was >compiled using the 4.10.UD2 tools. Durring the acceptance testing of >the application running under 7.21 engine we have run into a strange >problem. A specific query works most of the time but fails every >once in a while with an error of: > >-254 Too many or too few host variables given. > >I've had our developer look into it and he is rather perplexed as >well. Below is a short message from him describing what he is doing: > > I have a table called t_table and it has 9 >variables in it. I wrote a 4gl program called get_t_table to get >information from the t_table and it look as follow: > <snipped> > OPEN tmp_cursor > ................ > ................ > ................ > >At run time sometime I get an error code -254 for OPEN tmp_cursor. Is >this ever happen to you? If it is. How can you fix it? > >Me back again, has anyone come across this kind of problem? What was >done to fix it. Is the 7.21.UD1 engine a reliable version, or do I >need to upgrade? Any tips will be greatly apreaciated because of >course management is breathing hard down my back to make this >happen! > >David J. Hinkle > ----------------------- Rudy Fernandes GIC, Kuwait OL 7.20UC4, 4GL 6.04UC1 -----------------------