Cust.UpdateData method and case sensitivity with 9.05.607A and S

You could try to update it to something else and then update a second time with the corrected address.



________________________________
From: Tim Vonderhaar <tvonderhaar@...>
To: vantage@yahoogroups.com
Sent: Tuesday, February 21, 2012 8:20 AM
Subject: [Vantage] Re: Cust.UpdateData method and case sensitivity with 9.05.607A and SQL


Â
Does no response from the group indicate there is no work around for this problem?

--- In vantage@yahoogroups.com, "Tim Vonderhaar" <tvonderhaar@...> wrote:
>
> Testing our Dynamics CRM and Epicor two-way sync, I'm finding that the UpdateData method for Customer isn't honoring case. After doing a GetCustomer, I find the DS variable Address1 contains the string "street 1". If I update the DS by capitalizing the 'S' so it is now "Street 1", then perform an UpdateData method, the result in the actual customer table remains "street 1" with a lowercase 's'. I know the collation of the SQL database is CI, but I didn't expect this. Is there a flag, setting or work around for this?
>
> Tim
>




[Non-text portions of this message have been removed]
Testing our Dynamics CRM and Epicor two-way sync, I'm finding that the UpdateData method for Customer isn't honoring case. After doing a GetCustomer, I find the DS variable Address1 contains the string "street 1". If I update the DS by capitalizing the 'S' so it is now "Street 1", then perform an UpdateData method, the result in the actual customer table remains "street 1" with a lowercase 's'. I know the collation of the SQL database is CI, but I didn't expect this. Is there a flag, setting or work around for this?

Tim
Does no response from the group indicate there is no work around for this problem?

--- In vantage@yahoogroups.com, "Tim Vonderhaar" <tvonderhaar@...> wrote:
>
> Testing our Dynamics CRM and Epicor two-way sync, I'm finding that the UpdateData method for Customer isn't honoring case. After doing a GetCustomer, I find the DS variable Address1 contains the string "street 1". If I update the DS by capitalizing the 'S' so it is now "Street 1", then perform an UpdateData method, the result in the actual customer table remains "street 1" with a lowercase 's'. I know the collation of the SQL database is CI, but I didn't expect this. Is there a flag, setting or work around for this?
>
> Tim
>