I have an application that works fine on the development system. A simple Grid, with a link to a Form.
In development, when I turn on SQL debug, I see this when I go from the Grid to the form.
(informix): SELECT count(*) from packaddr where shipto_code=“1001”
(informix): SELECT shipto_code, p_custname, p_addr1, p_addr2, city_state, zip, p_addr4, dis_code, sony_flag, skid_tag_watermark, shipping_lead_days from packaddr WHERE (shipto_code=“1001”) AND (shipto_code = ‘1001’) order by shipto_code
When I move the application from development, I need to change the connection from native Informix, to Informix_PDO (which works and tests out out at least initially).
I get the Grid screen OK, and it displays as I would expect. But the Form does not find any records. The debug SQL shows
(pdo-informix): SELECT count(*) from packaddr where shipto_code="1001 "
(pdo-informix): SELECT shipto_code, p_custname, p_addr1, p_addr2, city_state, zip, p_addr4, dis_code, sony_flag, skid_tag_watermark, shipping_lead_days from packaddr WHERE (shipto_code="1001 ") AND (shipto_code = ‘’) order by shipto_code
Note that in the second one, the second ‘1001’ is missing.