[
https://issues.apache.org/jira/browse/OFBIZ-2396?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Scott Gray closed OFBIZ-2396.
-----------------------------
Resolution: Fixed
Fix Version/s: SVN trunk
Release Branch 9.04
Thanks Brian, fixed in all 3 versions
trunk - r770571
9.04 - r770574
4.0 - r770575
Instead of clearing the field I just used a set operation in place of
string-to-list so the old value will be overwritten.
> "Manage Picklist" errors out with MS-Sql when there is more than 1 pick list
> ----------------------------------------------------------------------------
>
> Key: OFBIZ-2396
> URL: https://issues.apache.org/jira/browse/OFBIZ-2396
> Project: OFBiz
> Issue Type: Bug
> Components: product
> Affects Versions: Release Branch 4.0
> Reporter: Brian Sanders
> Assignee: Scott Gray
> Fix For: Release Branch 4.0, Release Branch 9.04, SVN trunk
>
> Attachments: picklist.patch
>
>
> This may not affect other DBMS', but it definitely affects MS-Sql. Even
> though a "workaround" would be to only have 1 picklist at a time, I don't
> exactly consider that acceptable. Fortunately, it's an easy fix. It looks
> like this issue still lurks in the trunk as well. To sum it up,
> getPicklistSingleInfoInline is called for each picklist. In the method there
> is an "orderBy" list to which "sequenceId" is added. The first pass works
> fine, on the second pass, "sequenceId" is added to the list again and MS-Sql
> complains because the column is in the "order by" clause twice. The solution
> is to clear the field before-hand.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
