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

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