Hi Diego,

Em 8/6/2011 23:28, diegodelafuente escreveu:

> 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
>
>

Show us the correct error message perhaps it could help to identify your
problem.

I use a pretty old version of Crystal Reports (7.5) and I'm used to use
Stored Procedures without problem, but I use ODBC instead of OLE/DB.

see you !