IfxCommandBuilder Derive
Posted in 2008
eferreyra — — source: Usenet: comp.databases.informix
Hi, other issue, i create this stored procedure:
CREATE PROCEDURE GetProvincia
(ppvc_cod char(1))
RETURNING char(30);
define lpvc_des like base:provincias.pvc_des;
select pvc_des
into lpvc_des
from base:provincias
where pvc_cod = ppvc_cod;
return lpvc_des;
END PROCEDURE;
Then i use
discoveryCommand.CommandText = "database:GetProvincia";
discoveryCommand.CommandType =
System.Data.CommandType.StoredProcedure;
IfxCommandBuilder.DeriveParameters((IfxCommand)discoveryCommand);
After this call the method only add a single parameter, named "RETURN"
of type Int32 ?????
something missing ???