My application just passes command like "exec stpprocedure" etc which inturn calls sql functions like sqlexecute(). I use "exec stpprocedure" command in my application which inturn triggers sqlexecute() fucntion. sqlexecute...

Executing the stored procedure using SQL query analyser returns 1. But the problem is only when executing with sqlexecute() function.