Show number of column when their number is not match in FOR SELECT
------------------------------------------------------------------
Key: CORE-4242
URL: http://tracker.firebirdsql.org/browse/CORE-4242
Project: Firebird Core
Issue Type: Improvement
Reporter: Maxim Kuzmin
Priority: Trivial
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
