Wednesday, June 24, 2009

Single Quotes ( ' ) !?! And other Illegal Characters

Guys,

We used to have this problem when developing our applications that's using SQL Database, as the single quotation used to cause un-handled exception upon inserting the record to the database as it cause miss in string formatting.

However, we used to handle such issues with replacing the single quotation ( ' ) with the other single quotation ( ` ) with ASCII code of 44, now with GP the issue is here as well! checkout below Mariano and Davids Posts on this subject and their available workarounds:

David:

http://blogs.msdn.com/developingfordynamicsgp/archive/2009/06/22/microsoft-dynamics-gp-and-illegal-characters-part-1.aspx

Mariano:

http://dynamicsgpblogster.blogspot.com/2009/06/fixing-microsoft-dynamics-gp-and.html

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 - 79 - 999 65 85
Dynamics Innovations
daoudm@dynamicsinnovations.com
http://www.dynamicsinnovations.com/

1 comment:

David Musgrave [MSFT] said...

Keep in mind that these characters work fine most of the time. I was just explaining why they sometimes cause problems.

David
http://blogs.msdn.com/DevelopingForDynamicsGP/

Related Posts:

Related Posts with Thumbnails