What ODBC error do you get (AERROR()) ?
>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.
>
>
--sb--