RE: error 254

Just for reference: 254 Too many or too few host variables given. The number of host variables that you named in the INTO clause of this statement does not match the number of "?" place holders that you wrote into the statement. Locate the text of the statement (in a PREPARE or DECLARE statement), and verify the number of place holders. Then review the list in the INTO clause to see which item is incorrect. This error can be caused for various reasons. The most common two reasons I have found are: 1. A record variable is defined 'like' a whole table, (tablename.*) and a prepared statement has the select explicitly defined (select col1, col2, col3 ....) and the referenced table schema changes 2. A prepared select * is used and a record is explicitly defined and the table changes. Check first for recent table changes then look to the code. Derek M. Sleeper Management Information Consulting <mailto:dsleeper@micinc.com> dsleeper@micinc.com / <mailto:iidqs@brightpoint.com> iidqs@brightpoint.com -----Original Message----- From: pp [SMTP:jbarrera@isp.com] Sent: Wednesday, July 22, 1998 5:20 AM To: informix-list@iiug.org Subject: error 254 Hi, Does anyone knows what could cause this error? because the program that cause the error is working fine since many years. Help will be appreciate Pedro