what s wrong?

bumblebee · Post by **bumblebee** » Fri 24 Mar 2006 08:29

Hi...

i use Delphi 7 and MyDac 3,55 022 ...

my procedure :

CREATE PROCEDURE `xa`()
BEGIN

select * from stok_junc;

END;

when i run (call xa()) procedure script in mysql query browser (or mysql-front), results is following :

200, '', , , 350, 'TL', , '', , , '', '', '2005-01-01', , '1', '', '', , ''
201, '', , , 350, 'TL', , '', , , '', '', '2005-01-01', , '1', '', '', , ''
202, '009', 1, , 252, 'TL', , '', , , '', '', '2005-01-02', , '1', '0000000001', '', ,

but same spript is not run TStoredProcedure or TMyQuery component..
for exam :

TMyquery.connection=myconnection1;
TMyquery.sql.add('call xa()');
TMyQuery.active=true;

and then exception is "xa can' t return a resultset in the given context"

why not run procedure in mydac?

Antaeus · Post by **Antaeus** » Fri 24 Mar 2006 10:58

Unfortunately this version of MyDAC doesn't allow returning resultsets from stored procedures. You should upgrade to MyDAC 4 to use this capability.

bumblebee · Post by **bumblebee** » Fri 24 Mar 2006 11:33

Ok... thanks...