15.08.2022 20:42, Vlad Khorsun wrote:

Also, I don't like 'sql' word, especially after 'execute statement' and 'execute block'. Too much, as for me :) Syntax with 'with' instead of 'execute sql' looks much better to me, but it is already used in CTE's, thus it seems as not the best choice :(

using (p1 integer = :p1, p2 varchar(255) = :p2)
do select * from t where t.id = :p1 and t.name = :p2

or just

using (p1 integer = :p1, p2 varchar(255) = :p2)
select * from t where t.id = :p1 and t.name = :p2

?


Dmitry


Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to