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