My store procedure
delimiter |
create procedure iduser(pname varchar(30))
begin
insert into usuario (id,name) values (null,pname);
end
|
what I am making of made a mistake?
Query must return exactly result set -use Execute.
-
Maiquel Kappel
- Posts: 9
- Joined: Sun 30 Jan 2005 23:44
Query must return exactly result set -use Execute.
hi, I created one store procedure in mysql 5, when I execute call('name ') in the bank, saved the name ok, but when I try to use the MyStoredProc1 component occurs the following error, Query must return exactly result set -use Execute.
My store procedure
delimiter |
create procedure iduser(pname varchar(30))
begin
insert into usuario (id,name) values (null,pname);
end
|
what I am making of made a mistake?
My store procedure
delimiter |
create procedure iduser(pname varchar(30))
begin
insert into usuario (id,name) values (null,pname);
end
|
what I am making of made a mistake?
Re: Query must return exactly result set -use Execute.
You tried to execute MyStoredProc.Open for a query that doesn't execute SELECT. For these queries you need use MyStoredProc.Execute