Bug #37349 The parameter name '@' or '?'
Submitted: 11 Jun 2008 15:50 Modified: 23 Mar 2010 14:20
Reporter: Poul Bak Email Updates:
Status: Closed Impact on me:
Category:Connector / NET Documentation Severity:S3 (Non-critical)
Version:5.2.2 OS:Any
Assigned to: Tony Bedford CPU Architecture:Any

[11 Jun 2008 15:50] Poul Bak
This is a follow-up on the bug that I previously closed myself, because I had misunderstood.
I wondered, where I had read that we should use the '?' instead of '@', which is again the recommended identifier.

Well, it turns out, that I had simply read the helpfile included (my fault, never read the help file, lol)
Well, here are the topics, where it's recommended to use '?':

MySqlCommand Class (See 'Note' half way down)
MySqlDataAdapter..::.DeleteCommand Property (example code)
MySqlDataAdapter..::.InsertCommand Property (example code)
MySqlDataAdapter..::.SelectCommand Property  (example code)
MySqlDataAdapter..::.UpdateCommand Property  (example code)

How to repeat:
To repeat, read the helpfile

Suggested fix:
Change the help-text, so people like me don't misunderstand again :-)

To Reggie: Thanks for your mail, I chose to answer here 'officially'.

...and I totally agree, that using '@' is better. .Net users don't need user variables, they create their own in their programs. And making converting to MySql easier is the right choice. Now it's also easier to read MS' doc and examples.
[12 Jun 2008 5:56] Tonci Grgin
Hi Poul and thanks for your report. Verified just as described by looking into chm file distributed with c/NET 5.2.2. There appear to be some inconsistencies regarding this in web help too.
[17 Jun 2008 15:41] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

[17 Jun 2008 15:42] Reggie Burnett
I've updated the docs that ship with the product.  The online docs should now be updated.
[15 Jul 2008 18:42] Reggie Burnett
starting with 5.2 they should be using @ but ? will still work
[23 Mar 2010 14:20] Tony Bedford
I believe all instances of ? have been replaced by @, so closing this task.