How to Create MySQL Store Procedure in Navicat
Example:
BEGIN
SELECT * FROM CITY WHERE CITY_NME=NAME;
END
Save Store Procedure with TEST name
*****
In Paramter Textbox fill with NAME CHAR(20)
click run an entry "BATAM" or what ever CITY name
the query should be display with city fill
****************
now how to call within VFP
****************
Here an example:
MYSTS = "CALL TEST('BATAM')"
SQLEXEC(1, MYSTS, "MYCURSOR")
SELECT MYCURSOR
BROWSE
BEGIN
SELECT * FROM CITY WHERE CITY_NME=NAME;
END
Save Store Procedure with TEST name
*****
In Paramter Textbox fill with NAME CHAR(20)
click run an entry "BATAM" or what ever CITY name
the query should be display with city fill
****************
now how to call within VFP
****************
Here an example:
MYSTS = "CALL TEST('BATAM')"
SQLEXEC(1, MYSTS, "MYCURSOR")
SELECT MYCURSOR
BROWSE
Comments