4GL V7.31 placeholder problem?

[Malc P]

Hi
Testing 4GL V7.31 here, on HP-UX11i.
The following code has worked in 4GL 6.05 thru 7.20 for over 7 years.
Now in 7.31 it's failing at runtime - because when the cursor is
opened (with two arguments), it sees the two "?" in the MATCHES string
as placeholders, then screams and dies. Is this a newly introduced
bug, or have we just been lucky so far?

LET lc_sql = "SELECT sql_lkid_code",
" FROM sql_lookup_info",
" WHERE sql_lkid_code MATCHES 'CNST-??-00'",
" AND entityid_ref = ?",
" AND entityid_name = ?",
" AND status_ref = ", gn_active_ref
PREPARE pr_get_lead_sql FROM lc_sql
DECLARE cr_get_lead_sql CURSOR FOR pr_get_lead_sql
--
Malc_p

[Malc P]

Hi Gang
further to my recent post - I just compiled and ran the code with no
errors using R4GL - it's just I4GL that fails at runtime with:

Program stopped at "cursor.4gl", line number 23.
SQL statement error number -254.
Too many or too few host variables given.

Sometimes I feel like a guinea-pig for IBM........
--
Malc_p
[email]malc_p@btinternet.com[/email] (Malc P) wrote in message news:<8c28402a.0310080616.69a9fbb0@posting.google. com>...

> Hi
> Testing 4GL V7.31 here, on HP-UX11i.
> The following code has worked in 4GL 6.05 thru 7.20 for over 7 years.
> Now in 7.31 it's failing at runtime - because when the cursor is
> opened (with two arguments), it sees the two "?" in the MATCHES string
> as placeholders, then screams and dies. Is this a newly introduced
> bug, or have we just been lucky so far?
>
> LET lc_sql = "SELECT sql_lkid_code",
> " FROM sql_lookup_info",
> " WHERE sql_lkid_code MATCHES 'CNST-??-00'",
> " AND entityid_ref = ?",
> " AND entityid_name = ?",
> " AND status_ref = ", gn_active_ref
> PREPARE pr_get_lead_sql FROM lc_sql
> DECLARE cr_get_lead_sql CURSOR FOR pr_get_lead_sql

[Colin Bull]

Malc P wrote

>
> Sometimes I feel like a guinea-pig for IBM........

I hear they are good roasted :-)
With a few parsnips :-))

Colin Bull
[email]c.bull@videonetworks.com[/email]

sending to informix-list

[Mark D. Stock]

Malc P wrote:

> Hi Gang
> further to my recent post - I just compiled and ran the code with no
> errors using R4GL - it's just I4GL that fails at runtime with:
>
> Program stopped at "cursor.4gl", line number 23.
> SQL statement error number -254.
> Too many or too few host variables given.

I hope you've open a case with IBM.

> Sometimes I feel like a guinea-pig for IBM........

Well no code is bug free. The test for you is how quickly IBM fix your problem.

Cheers,
--
Mark.

+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /|
| Mydas Solutions Ltd [url]http://MydasSolutions.com[/url] |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+

sending to informix-list

[Malc P]

"Mark D. Stock" <mdstock@mydassolutions.com> wrote in message

>
> I hope you've open a case with IBM.
>

Yup, I had a very prompt and effective response from Vijay, who has
taken it on board and confirmed it's a new bug.

*Very* impressed. Just how it should be ;-)

Malc

[John Carlson]

On 10 Oct 2003 01:12:58 -0700, [email]malc_p@btinternet.com[/email] (Malc P) wrote:

>"Mark D. Stock" <mdstock@mydassolutions.com> wrote in message

>>
>> I hope you've open a case with IBM.
>>

>
>Yup, I had a very prompt and effective response from Vijay, who has
>taken it on board and confirmed it's a new bug.
>
>*Very* impressed. Just how it should be ;-)
>

Change for the better? Good to hear good things about support. I
haven't had as many issues as others, but then I haven't had as many
issues as other . . . . 8-)

[Andrew Hamm]

Malc P wrote:

>
> Yup, I had a very prompt and effective response from Vijay, who has
> taken it on board and confirmed it's a new bug.
>
> *Very* impressed. Just how it should be ;-)

Apart from your stray ?? in the MATCHES, your original problem implies that
7.31 is now counting ? and supplied host variables and complaining if the
counts don't match.

I hope 4GL does not now consider it wrong to say

prepare thing from " .......... ? and ....? and .....?......."

open thing using a, b

We've got a few critical pieces of code that must run with unmatched counts.
It's all because 4GL is so dreadfully un-dynamic when it comes to their
datatypes such as records or argument lists - when the code has to be
flexible you need to bend the rools in the area of the USING clause.

[Jonathan Leffler]

Andrew Hamm wrote:

> Malc P wrote:

>>Yup, I had a very prompt and effective response from Vijay, who has
>>taken it on board and confirmed it's a new bug.
>>
>>*Very* impressed. Just how it should be ;-)

>
> Apart from your stray ?? in the MATCHES, your original problem implies that
> 7.31 is now counting ? and supplied host variables and complaining if the
> counts don't match.
>
> I hope 4GL does not now consider it wrong to say
>
> prepare thing from " .......... ? and ....? and .....?......."
>
> open thing using a, b
>
> We've got a few critical pieces of code that must run with unmatched counts.
> It's all because 4GL is so dreadfully un-dynamic when it comes to their
> datatypes such as records or argument lists - when the code has to be
> flexible you need to bend the rools in the area of the USING clause.

No - the problem was that an ISO C compiler was interpreting ??- as a
trigraph for tilde, and I4GL wasn't making sure it didn't.


--
Jonathan Leffler #include <disclaimer.h>
Email: [email]jleffler@earthlink.net[/email], [email]jleffler@us.ibm.com[/email]
Guardian of DBD::Informix v2003.04 -- [url]http://dbi.perl.org/[/url]

[Andrew Hamm]

Jonathan Leffler wrote:

>
> No - the problem was that an ISO C compiler was interpreting ??- as a
> trigraph for tilde, and I4GL wasn't making sure it didn't.

Phew;-) Thanks for the clarification