On 11-02-2022 17:46, Mark Rotteveel wrote:
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.
See discussions:
- subject "isc_info_sql_stmt_type/isc_info_sql_stmt_flags" on the 19th
and 20th of August 2021
- subject "Firebird 5 and Update...Returning" on the 26th of November 2021
Mark
--
Mark Rotteveel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
