ID: 31592 Updated by: [EMAIL PROTECTED] Reported By: andreybl at matrix dot co dot il -Status: Open +Status: Feedback Bug Type: Informix related Operating System: RedHat 3.0 ES PHP Version: 5.0.4, 4.3.11 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2005-05-04 17:07:14] andreybl at matrix dot co dot il Tried on version 4.3.11. No change. I.e. it is impossible to use ifx_getsqlca in case when some SQL error occurred. ------------------------------------------------------------------------ [2005-01-18 09:26:17] andreybl at matrix dot co dot il Description: ------------ In case when ifx_query() fails it returns FALSE as result id. When ifx_getsqlca gets false as result id, it complains: <b>Warning</b>: ifx_getsqlca(): supplied resource is not a valid Informix Result resource in <b> This is actually a BUG, since when the sql-query fails, it is stll neccessary sometimes, to get the sqlca structure. E.g. to get the ISAM error. Reproduce code: --------------- sleep(20); $db->begin_transaction(); $sql = "update tb set recordingdate = '2005-01-12 11:33:57.597' where id = 138"; if (!($resid = ifx_query($sql, $db->connid))) { echo "Failed to open:\n$sql\n".ifx_error()."\n"; $db->rollback_transaction(); $sqlca = ifx_getsqlca($resind); var_dump($sqlca); die(); } else { echo "Open successfull\n"; ifx_free_result($resid); $db->commit_transaction(); } Expected result: ---------------- ifx_getsqlca should get me the sqlca structure and not an error. Actual result: -------------- ifx_getsqlca fails, the following message appears: <b>Warning</b>: ifx_getsqlca(): supplied argument is not a valid Informix Result resource in <b> ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=31592&edit=1
