Bug #37349 The parameter name '@' or '?'
Submitted: 11 Jun 2008 17:50 Modified: 16 Jul 2008 14:11
Reporter: Poul Bak
Status: Need Doc Info
Category:Connector/Net: Docs Severity:S3 (Non-critical)
Version:5.2.2 OS:Any
Assigned to: MC Brown Target Version:
Triage: D4 (Minor)

[11 Jun 2008 17:50] Poul Bak
Description:
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 7: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 17: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:

  http://lists.mysql.com/commits/48017
[17 Jun 2008 17:42] Reggie Burnett
I've updated the docs that ship with the product.  The online docs should now be updated.
[15 Jul 2008 20:42] Reggie Burnett
starting with 5.2 they should be using @ but ? will still work