Subject | Re: What API do you use to get affected row count? |
---|---|
Author | Jeff Lynn |
Post date | 2006-04-27T17:52:36Z |
So far, here is what I figured out by walking the cluster returned
from isc_dsql_sql_info() on an update stmt:
two serial clusters returned:
First is isc_info_sql_records.
Second is isc_info_end;
the isc_info_sql_records clusters embedded with 4 clusters:
Cluster 1.1 is isc_info_req_update_count, which imbedded count value
0x0001.
Cluster 1.2 is isc_info_req_delete_count, which imbedded count value
0x0000.
Cluster 1.3 is isc_info_req_select_count, which imbedded count value
0x0001.
Cluster 1.4 is isc_info_req_insert_count, which imbedded count value
0x0000.
The only stme executed is SQL update, why did the select return a
count of 1?
jml
from isc_dsql_sql_info() on an update stmt:
two serial clusters returned:
First is isc_info_sql_records.
Second is isc_info_end;
the isc_info_sql_records clusters embedded with 4 clusters:
Cluster 1.1 is isc_info_req_update_count, which imbedded count value
0x0001.
Cluster 1.2 is isc_info_req_delete_count, which imbedded count value
0x0000.
Cluster 1.3 is isc_info_req_select_count, which imbedded count value
0x0001.
Cluster 1.4 is isc_info_req_insert_count, which imbedded count value
0x0000.
The only stme executed is SQL update, why did the select return a
count of 1?
jml