Subject | Problem with stored procure and Crystal reports |
---|---|
Author | diegodelafuente |
Post date | 2011-06-09T02:28:38Z |
Hi.
I created a select-SP using IB Expert.
SET TERM ^ ;
CREATE PROCEDURE ACTUALIZACIONES_S
returns (
versioncol varchar(5),
fechaactualizacion date)
as
begin
for select versioncol,
fechaactualizacion
from actualizaciones
into :versioncol,
:fechaactualizacion
do
begin
suspend;
end
end^
SET TERM ;
After that I opened CR XI and, using ZStyle IBOLE provider, I tried to open the DB to use the SP created.
I could connect to the DB and select the SP from the list.
After that, CR shows a Dynamic SQL error.
I can access to any table or data using "Add command" option and typing any select sentence.
Regards
Diego
I created a select-SP using IB Expert.
SET TERM ^ ;
CREATE PROCEDURE ACTUALIZACIONES_S
returns (
versioncol varchar(5),
fechaactualizacion date)
as
begin
for select versioncol,
fechaactualizacion
from actualizaciones
into :versioncol,
:fechaactualizacion
do
begin
suspend;
end
end^
SET TERM ;
After that I opened CR XI and, using ZStyle IBOLE provider, I tried to open the DB to use the SP created.
I could connect to the DB and select the SP from the list.
After that, CR shows a Dynamic SQL error.
I can access to any table or data using "Add command" option and typing any select sentence.
Regards
Diego