I'm trying to create a stored procedure through the connector (v1.0.5); I
define the CommandText property of a MySqlCommand as:
cmd.CommandText = @"
delimiter '//';
drop procedure if exists proc_name
\g
create procedure proc_name()
begin
... sql statement list...
/* here a comment with a ? in it */
... more sql statements...
end
\g
delimiter ';'//
";
followed by a cmd.ExecuteNonQuery(), which throws an exception, complaining
that "Parameter '?' must be defined".
As the '?' is within a comment, I would normally expect the parser to ignore
it, but this is apparently not the case. Comments, anybody ?
Thanks,
3 messages in com.mysql.lists.dotnetComments in MySqlCommand.CommandText ?
