Re: -410 Prepare statement failed... BUT NO PREPARE!
Kerry Sainsbury (kerry@kcbbs.gen.nz) wrote:
: 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.
Here's a small program which illustrates the bug:
---------------------------------------------------
MAIN
DEFINE i,j SMALLINT
# CREATE TABLE kerry(kjs CHAR(5)) # <---- Create this first
FOR j = 1 TO 2
DATABASE eunice # <----- Your database goes here
DELETE FROM kerry
FOR i = 1 TO 2
INSERT INTO kerry
VALUES ("hello")
END FOR
CLOSE DATABASE
END FOR
END MAIN
---------------------------------------
Anybody else get this bug?
Please DON'T state the obvious work-around for the above program!
Thanks,
Kerry S
--------------------------------------,-------------------------------------
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:/?