Subject | RE: Full Cross Tab but unknown column headers |
---|---|
Author | |
Post date | 2014-01-04T06:41:59Z |
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
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