STORED PROCEDURE

Alberto · Post by **Alberto** » Sun 18 Jun 2006 21:43

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

Antaeus · Post by **Antaeus** » Mon 19 Jun 2006 07:55

MyDAC 3.55 doesn't support retrieving result set from stored procedures. You should upgrade to MyDAC 4 to use this capability.