-410 Prepare statement failed... BUT NO PREPARE!

Posted in 1994

Kerry Sainsbury — Thu, 06 Oct 1994 21:12:19 +1200 — source: Informix-list mailing list archive (1991-1998)

My 4GL-RDS (4.10.UC1) program, running against a SE 4.10.UG1 database, told me today: "SQL Statement Error -410, Prepare statement failed or was not executed" The line it barfed on did NOT have a PREPARE statement, only an INSERT. I actually encountered this problem about a year ago in another program, and ignored it at the time because it was in an inhouse utility, but today's error is in a system we will be using live. The error only happens the second time the routines are used. Maybe it's got something to do with opening/closing databases? Help! --------------------------------------,------------------------------------- Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ Quanta Systems, Auckland, New Zealand | kcbbs.gen.nz:/informix/* | mathcs.emory.edu:/pub/informix/faq/* +64 9 377-4473 (work) 276-5546 (home) | quasar.ucar.edu:/?