I have a function/store proc in Maria DB
CREATE DEFINER=`root`@`localhost` PROCEDURE `test1`(var1 varchar(100))
BEGIN
select * from ttype where kode=var1;
END
When I try to acces it from my visual foxpro application it’s not running.
I try :
Sqlexec(kon,”call test1 (‘ABC’)”) –> not running
I try :
sqlexec(kon,”select * from ttype where kode=’ABC'”,”test”) –ti’s running well..
HOw to call store proc in Mariadb from visual foxpro application?
1