Page 1 of 1

STORED PROCEDURE

Posted: Sun 18 Jun 2006 21:43
by Alberto
Hi !!

I Have this procedure created
CREATE PROCEDURE `syscoi7`.`modelos`()
DETERMINISTIC
BEGIN
Select Empresa, Codigo, ClaveProveedor, Descripcion, Descripcion2,
Ubicacion, Corrida, Color, Descuento, Precio1, Precio2, Precio3,
Precio4, Precio5, Precio6, Precio7, Precio8, Precio9, Precio10
From Productos ;
END


Since I capture the result of the procedure in a grid
Use Delphi 7 MyDac 3.55
Thank you!!

Posted: Mon 19 Jun 2006 07:55
by Antaeus
MyDAC 3.55 doesn't support retrieving result set from stored procedures. You should upgrade to MyDAC 4 to use this capability.