Move from 5.01 to 7.21 4gl problem

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: DEFINE h_t_table RECORD file_nbr LIKE t_table.file_nbr, misc_seq LIKE t_table.misc_seq, repo_id LIKE t_table.repo_id, ident_nbr LIKE t_table.ident_nbr, source LIKE burmsc.source, rptd_mm LIKE t_table.rptd_mm, rptd_yy LIKE burmsc.rptd_yy, misc_text LIKE t_table.misc_text, misc_text_len LIKE t_table.misc_text_len END RECORD DECLARE tmp_cursor CURSOR FOR SELECT file_nbr, misc_seq, repo_id, ident_nbr, source, rptd_mm, rptd_yy, misc_text, misc_text_len INTO h_t_table.file_nbr, h_t_table.misc_seq, h_t_table.repo_id, h_t_table.ident_nbr, h_t_table.source, h_t_table.rptd_mm, h_t_table.rptd_yy, h_t_table.misc_text, h_t_table.misc_text_len FROM t_table WHERE file_nbr = g_curr_file_nbr AND source = the_source AND repo_id = the_repo_id AND ident_nbr = the_ident_nbr 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 Systems/Database Administrator email: dhinkle@firstam.com First American Credco Voice: (619) 929-6000 x6247 5927 Priestly Drive Ste 250 Fax: (619) 929-6011 Carlsbad, CA 92008 --------------------------------------------------------------------------- Why ask Why: Why do we drive on parkways and park on driveways? ---------------------------------------------------------------------------