CREATE PROCEDURE SELTMPVENTA
RETURNS (
ART VARCHAR (80),
PV NUMERIC (15, 2),
CLI VARCHAR (50),
FEC DATE,
CF VARCHAR (2),
FOL INTEGER,
MV VARCHAR (50),
SUBT NUMERIC (15, 2),
DES NUMERIC (15, 2),
VT NUMERIC (15, 2),
ABO NUMERIC (15, 2),
ANT NUMERIC (15, 2),
PLA NUMERIC (2, 1),
FIN NUMERIC (2, 1),
CANTIDAD INTEGER,
COD VARCHAR (6),
TNETO NUMERIC (15, 2),
TOD NUMERIC (15, 2),
TC NUMERIC (15, 2))
AS
BEGIN
FOR SELECT * FROM TMPVENTAS
INTO :ART, :PV, :CLI, :FEC, :CF, :FOL, :MV,:SUBT,
ES, :VT, :ABO, :ANT,
:PLA, :FIN, :CANTIDAD, :COD, :TNETO, :TOD, :TC
DO
SUSPEND;
END
me marca el sigiente error -
frmCompile.q_COMPILE:
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.
alguien tiene idea???
gracias