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
malc_p@btinternet.com (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