On Sat, Jan 4, 2014 at 2:41 AM, <venussoftop@...> wrote:

 

Hi Walter

Okay I upgraded to FB 2.5.2.26540.  I have successfully created the SPs Parser and Crear_Tabla_Pivot but when I try to create the SP called ACTUALIZAR_TABLA_PIVOT (I tried the one from your web page as well as the one you sent me as a download) I get the error:
 
 Executing statement...

Error: *** IBPP::SQLException ***

Context: Statement::Execute(

CREATE PROCEDURE ACTUALIZAR_TABLA_PIVOT(
   tcTablaPivot             VARCHAR(  28),
   tcVista                  VARCHAR(  28),
   tcPr...
...
...STATEMENT lcActualizar;
      END
   END
 
END )
Message: isc_dsql_execute2 failed

SQL Message : -607
This operation is not defined for system tables.

Engine Code    : 335544351
Engine Message :
unsuccessful metadata update
STORE RDB$PROCEDURES failed
Malformed string


Total execution time: 0.015s


Surprisingly I was able to create this SP well in FB 2.1.4!  Please advise.

Thanks and regards
Bhavbhuti