On 2022-02-11 12:54, Jiří Činčura wrote:
Is there a way to get as a response to isc_info_sql_stmt_type for "INSERT ... RETURNING" isc_info_sql_stmt_insert instead of isc_info_sql_stmt_exec_procedure? Or something similar that would specify it's an "insert"?
No. In fact, with Firebird 5, statements with RETURNING can even identify as isc_info_sql_stmt_select. The statement types are more about how you should handle statement execution than anything else. When it was discussed last time, I believe the idea was raised to add a new info type to get this information, but that it would first need a real use case to do so. I'll see if I can find that discussion.
Mark Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel