Hi All,

MySQL 5 has triggers and stored procedures and I've been fighting trying to execute a simple MySQL stored procedure from within Visual Foxpro but it keeps failing.


MySQL 5 side:


delimiter $$

drop function if exists 'somedatabase'.'add'$$
create function 'add'(iParm1 INT, iParm2 INT)returns int(11)
begin
return iParm1+iParm2;
end$$

delimiter;


The above executes fine manually from withing the query browser ( ex. select somedatabase.add(1,1) ) but fails when I attempt to run it from within Foxpro. My connection is good and read and writes work just fine.


Foxpro side:


MySQLcon = sqlconnect("someDSN","userid","userpwd")

MySQL_Result = sqlexec(","select somedatabase.add(1,1)")


I've also tried "somedatabase.add(1,1)" and "add(1,1)" in place of the above select statement but it fails returning a -1.



Thanks in advance,

Don