I'm having a problem getting parameters working.
Mysql 5.0.16
mysql-connector-net-1.0.7
VB.NET 1.1
mysql> SHOW CREATE PROCEDURE tbl_slct \G
*************************** 1. row ***************************
Procedure: tbl_slct
sql_mode:
Create Procedure: CREATE PROCEDURE `tbl_slct`(IN tbl CHAR(64))
READS SQL DATA
BEGIN
SET @s = CONCAT('SELECT * FROM ' , tbl);
PREPARE stmt FROM @s;
EXECUTE stmt;
END
1 row in set (0.00 sec)
Public Function Test() As DataTable
If myConn.State <> ConnectionState.Open Then
myConn.ConnectionString = myConnString
myConn.Open()
End If
Test = New DataTable
Dim myCmd As New MySql.Data.MySqlClient.MySqlCommand("tbl_slct", myConn)
myCmd.CommandType = CommandType.StoredProcedure
myCmd.Parameters.Clear()
myCmd.Parameters.Add(New MySql.Data.MySqlClient.MySqlParameter("&tbl",
"escdofficer"))
myCmd.Parameters("&tbl").Direction = ParameterDirection.Input
Dim myAdapter As New MySqlDataAdapter(myCmd)
myAdapter.Fill(Test) '*** raises MySqlException
End Function
"Exception trying to retrieve parameter info for tbl_slct: Parameter 'tbl'
is not defined"
What am I missing?
Thanks,
Steve
