General information
Category:
Coding, syntax & commands
Title:
Executing a mysql stored procedure
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only