Professional Web Applications Themes

4GL V7.31 placeholder problem? - Informix

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 ...

  1. #1

    Default 4GL V7.31 placeholder problem?

    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 Guest

  2. #2

    Default Re: 4GL V7.31 placeholder problem?

    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_pbtinternet.com[/email] (Malc P) wrote in message news:<8c28402a.0310080616.69a9fbb0posting.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
    Malc P Guest

  3. #3

    Default RE: 4GL V7.31 placeholder problem?


    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.bullvideonetworks.com[/email]

    sending to informix-list
    Colin Bull Guest

  4. #4

    Default Re: 4GL V7.31 placeholder problem?


    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:mdstockMydasSolutions.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
    Mark D. Stock Guest

  5. #5

    Default Re: 4GL V7.31 placeholder problem?

    "Mark D. Stock" <mdstockmydassolutions.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
    Malc P Guest

  6. #6

    Default Re: 4GL V7.31 placeholder problem?

    On 10 Oct 2003 01:12:58 -0700, [email]malc_pbtinternet.com[/email] (Malc P) wrote:
    >"Mark D. Stock" <mdstockmydassolutions.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-)
    John Carlson Guest

  7. #7

    Default Re: 4GL V7.31 placeholder problem?

    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.


    Andrew Hamm Guest

  8. #8

    Default Re: 4GL V7.31 placeholder problem?

    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]jlefflerearthlink.net[/email], [email]jlefflerus.ibm.com[/email]
    Guardian of DBD::Informix v2003.04 -- [url]http://dbi.perl.org/[/url]

    Jonathan Leffler Guest

  9. #9

    Default Re: 4GL V7.31 placeholder problem?

    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


    Andrew Hamm Guest

Similar Threads

  1. placeholder error
    By lnatz in forum PERL Modules
    Replies: 1
    Last Post: August 3rd, 05:56 PM
  2. Usercontorl in a placeholder
    By Pradeep in forum ASP.NET Building Controls
    Replies: 1
    Last Post: November 3rd, 11:34 PM
  3. Build control in a placeholder or like a placeholder
    By nail in forum ASP.NET Building Controls
    Replies: 0
    Last Post: September 10th, 07:57 PM
  4. Placeholder child of child control event problem.
    By caldera in forum ASP.NET Building Controls
    Replies: 1
    Last Post: May 28th, 07:56 AM
  5. Placeholder Question
    By trinitypete in forum ASP.NET General
    Replies: 2
    Last Post: July 1st, 12:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139