STORED PROCEDURE

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Alberto

STORED PROCEDURE

Post by Alberto » Wed 28 Jun 2006 03:12

Which is the correct way of calling a stored procedure?

My Table is Big enough Has 100,000 Records.


Example:

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

MyDac 4.30.1.15 Delphi 7

Tanks !!!!

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Thu 29 Jun 2006 11:58

To call stored procedure you should use TMyStoredProc component.

Post Reply