Hi ! I work in a company using Firebird 2.1. I built a procedure having an single output parameter. If I use it inside a single Select command or inside a View, it works fine. The question is: if I want to see the structure of a view that calls that procedure, I can´t see it. Instead, I receive an error message that says "Precompiler Error: 'B341VALIDARCB'." (in a generic manner, "Precompiler Error: '[procedure name]'.". I'd like to see the structure of the vision that I need. If I get this message, I think something must be wrong with either the procedure or the view. I send the image of the structure attached. The basic procedure code is bellow.: CREATE PROCEDURE B341VALIDARCB( COD_BANCO VARCHAR(3) CHARACTER SET WIN1252 DEFAULT NULL, COD_AGENCIA VARCHAR(4) CHARACTER SET WIN1252 DEFAULT NULL, CARTEIRA VARCHAR(3) CHARACTER SET WIN1252 DEFAULT NULL, CONTA VARCHAR(6) CHARACTER SET WIN1252 DEFAULT NULL, VALOR DECIMAL(18, 2) DEFAULT 0, NOSSO_DOCUMENTO VARCHAR(8) CHARACTER SET WIN1252 DEFAULT NULL, CODIGODEBARRAS VARCHAR(50) CHARACTER SET WIN1252 DEFAULT NULL) RETURNS( AVALIACAO VARCHAR(50) CHARACTER SET WIN1252) AS BEGIN AVALIACAO = '';
IF (some condition) THEN AVALIACAO = AVALIACAO || 'Cód.do banco errado - '; IF (another condition) THEN AVALIACAO = AVALIACAO || 'Cód.da agência errado - '; /* other conditions */ IF (AVALIACAO = '') THEN AVALIACAO = 'Código de barras ok'; SUSPEND; END; No special condition, and the output field is handled only to receive the value according to the logical results inside the procedure. And if you look at the picture I send, you will see that the procedure is called by a sub Select inside the view. Does someone can give me some light about the possible problem in the code or in the solution itself ? Or is this a bug ? Thanks a lot, best regards, Roberto Camargo. [Non-text portions of this message have been removed]
