Re: prepared statements with "where current of" failing

In article <380b55f3.918058@news>, Douglas Wilson <dwilson@gtemail.net> writes >On Fri, 22 Oct 1999 00:36:52 GMT, Gregory King <gking@ibcinc.com> wrote: > > >> >> let scratch = "update test_table set the_string = the_string where >>current of curs1" >> prepare exec_stat from scratch > >>Informix also told us that this type of statement is no longer >>supported. They suggested that we simply change the execute statement >>to be the text of the scratch variable. > >Didn't Informix tell you about the 'cursor_name' (I think) function >mentioned in the 4gl supplement? Look there, there's instructions on >how to use it. I'd say RTFM, but it is a bit hard to find if you don't >know where it is, though I'm sure you could have found this >exact problem with the solution on dejanews or in the CDI archives. > >I'm a bit worried about that part about 'no longer being supported', since >its in the supplement, it must be supported (though in a different syntax), Correct, you have to use the cursor_name function. >so I wonder if you just got an idiot at tech support (likely), >or if they're really not going to support preparing that sort of statement >(not likely). > >Its bad enough that a 'USING' clause is not supported with a FOREACH >statement. I'd been putting 'OPEN ... USING' before my FOREACH's or >using 'FOREACH ... USING' for forever with no problem, then the day >I have a problem with it I'm told its not supported. Oh well, now I'm ?? It was added to 4GL 6.0X (X>=2 ??) certainly 6.01 4GL has problems like no cursor name function but 6.02 seems to have all 6.0X features. 4GL 4.x does not support FOREACH using.. >getting offtrack. Maybe if Jonathan reads this he can do something >about it ...? :) > >Cheers, >Douglas Wilson -- David Williams

On Fri, 22 Oct 1999 03:32:28 +0100, David Williams <djw@smooth1.demon.co.uk> wrote: >In article <380b55f3.918058@news>, Douglas Wilson <dwilson@gtemail.net> >writes >>Its bad enough that a 'USING' clause is not supported with a FOREACH >>statement. I'd been putting 'OPEN ... USING' before my FOREACH's or >>using 'FOREACH ... USING' for forever with no problem, then the day >>I have a problem with it I'm told its not supported. Oh well, now I'm > > ?? It was added to 4GL 6.0X (X>=2 ??) certainly 6.01 4GL has > problems like no cursor name function but 6.02 seems to have all > 6.0X features. Yes it has it, but I (and the tech support guys I spoke with) could find no documentation on it, so they said it was an unsupported feature; i.e. it works, but if you have any problems with it (like the bug I was experiencing), don't expect help from them. They did ask me if I wanted to put in a feature request, which I did. We are on 7.31 online, & 6.0something 4gl for the record. Cheers, Douglas Wilson