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
