15.08.2022 13:24, Adriano dos Santos Fernandes пишет:
On 15/08/2022 04:16, Simonov Denis via Firebird-devel wrote:
Very good feature, reminds me of the functionality from Oracle
WITH Procedure p1 ...
AS
...
FUNCTION f1 ...
AS
...
SELECT...
Firebird does not have any support for client named parameters.
As Mark told, it will require client support.
Just try to implement EXECUTE STATEMENT with your syntax and support for
named parameters, then it will become clear what I'm talking about. My
option is this.
I suppose if standalone statements is going to have support of named
parameters as EXECUTE STATEMENT, undeclared named parameters are going
to be automatically declared and comes after the explicit ones.
I'm talking about the fact that EXECUTE STATEMENT supports named
parameters, including those for EXECUTE BLOCK. There's even a special
query preparser for that. Those who implement client libraries will have
to do much the same. And if for EXECUTE BLOCK the prepaser is quite
simple (named parameters need to be searched only between EXECUTE BLOCK
and the first AS), then for such a syntax it will not be very trivial.
In your version, I don't see how even EXECUTE STATEMENT can work with
named parameters.
Adriano
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
