You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
CREATE OR ALTER PROCEDURE TEST_SP (
PARAM1 INTEGER,
PARAM2 INTEGER,
PARAM3 INTEGER)
AS
BEGIN
END
Normal executing is:
EXECUTE PROCEDURE TEST_SP(1, 1, 0);
But FB allow executing with error in the brackets, like this:
EXECUTE PROCEDURE TEST_SP(1), 1, 0;
The text was updated successfully, but these errors were encountered:
I was speaking about EXECUTE PROCEDURE. SELECT FROM PROCEDURE has different grammar rules and parenthesis are mandatory there.
> Optional parenthesis leads to errors in writing query. I stepped on this several times.
Perhaps. And personally I'd prefer parenthesis to be mandatory in all cases. But I can easily imagine users writing arguments without parenthesis just because "it was always allowed". And I doubt we should break them without strong reasons.
Submitted by: Maxim Kuzmin (cybermax)
CREATE OR ALTER PROCEDURE TEST_SP (
PARAM1 INTEGER,
PARAM2 INTEGER,
PARAM3 INTEGER)
AS
BEGIN
END
Normal executing is:
EXECUTE PROCEDURE TEST_SP(1, 1, 0);
But FB allow executing with error in the brackets, like this:
EXECUTE PROCEDURE TEST_SP(1), 1, 0;
The text was updated successfully, but these errors were encountered: