php informix query

The following excerpt of code: $sSql = "select max(resdate) as maxdate from tctores" . " where ornum = " . $iOrnum . " and oritem = " . $iOritem; $iResultid = ifx_query($sSql, $iConnection); $Row = ifx_fetch_row($iResultid); $iRes = ifx_free_result($iResultid); Produces this warning: Warning: Open cursor fails ( [SQLSTATE=00 000 SQLCODE=-242]) in /var/www/html/includefiles/ifx_ddlfunctions.inc on line 58 Line 58 is the line that runs ifx_query. This code is part of a function that returns order details and works for most orders I pass into it. Most orders have about 50 records to calculate the max(resdate) but the order producing the above warning has about no records for this particular table. (Not sure if this is relevant). Informix database is 7.2 SE. PHP is v4.1.2. The sqlcode 242 suggests a table permission problem but it is not this as other orders will work OK with this code. **************************************************** This e-mail is intended for the recipient only and may contain confidential information. If you are not the intended recipient then you should reply to the sender and take no further ation based upon the content of the message. Internet e-mails are not necessarily secure and CCM Limited does not accept any responsibility for changes made to this message. Although checks have been made to ensure this message and any attchments are free from viruses the recipient should ensure that this is the case. ****************************************************