Bookmark this on Delicious Share on Facebook

PHP : Function Reference : Informix Functions : ifx_getsqlca

ifx_getsqlca

Get the contents of sqlca.sqlerrd[0..5] after a query ()
array ifx_getsqlca ( resource result_id )

Example 1075. Retrieve Informix sqlca.sqlerrd[x] values

copy to clipboard

<?php
/* assume the first column of 'sometable' is a serial */
$qid = ifx_query("insert into sometable

                  values (0, '2nd column', 'another column') ", $connid);

if (!$qid) {

    /* ... error ... */
}
$sqlca = ifx_getsqlca($qid);
$serial_value = $sqlca["sqlerrd1"];

echo "The serial value of the inserted row is : $serial_value<br />\n";
?>

Change Language

Follow Navioo On Twitter

ifx_affected_rows
ifx_blobinfile_mode
ifx_byteasvarchar
ifx_close
ifx_connect
ifx_copy_blob
ifx_create_blob
ifx_create_char
ifx_do
ifx_error
ifx_errormsg
ifx_fetch_row
ifx_fieldproperties
ifx_fieldtypes
ifx_free_blob
ifx_free_char
ifx_free_result
ifx_get_blob
ifx_get_char
ifx_getsqlca
ifx_htmltbl_result
ifx_nullformat
ifx_num_fields
ifx_num_rows
ifx_pconnect
ifx_prepare
ifx_query
ifx_textasvarchar
ifx_update_blob
ifx_update_char
ifxus_close_slob
ifxus_create_slob
ifxus_free_slob
ifxus_open_slob
ifxus_read_slob
ifxus_seek_slob
ifxus_tell_slob
ifxus_write_slob

hits counter