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
Example:
EXECUTE BLOCK
AS
DECLARE VARIABLE FNAME CHAR(31);
BEGIN
FOR SELECT
F.RDB$FIELD_NAME,
F.RDB$QUERY_NAME
FROM
RDB$FIELDS F
INTO
:FNAME
DO
BEGIN
END
END
Firebird return exception:
count of column list and variable list do not match.
Dynamic SQL Error.
SQL error code = -313.
count of column list and variable list do not match.
But if the number of columns is large, then it is difficult to learn, where the error. The exact number will make it possible to quickly find where the error - in SELECT or in INTO.
The text was updated successfully, but these errors were encountered:
Submitted by: Maxim Kuzmin (cybermax)
Example:
EXECUTE BLOCK
AS
DECLARE VARIABLE FNAME CHAR(31);
BEGIN
FOR SELECT
F.RDB$FIELD_NAME,
F.RDB$QUERY_NAME
FROM
RDB$FIELDS F
INTO
:FNAME
DO
BEGIN
END
END
Firebird return exception:
count of column list and variable list do not match.
Dynamic SQL Error.
SQL error code = -313.
count of column list and variable list do not match.
But if the number of columns is large, then it is difficult to learn, where the error. The exact number will make it possible to quickly find where the error - in SELECT or in INTO.
The text was updated successfully, but these errors were encountered: