SQL collation
Reinhard
Member Posts: 249
Hi there.
We migrated to SQL for version 4.0 SP3.
We have two types of sales orders, with number series SO-###### and SO-ENG######
ENG are engineering orders, we don't have that many. Before the migration, ENG orders were sorted before SO orders, so the last order in the list was the most recent actual order. After the migration, ENG orders are sorted after SO orders and regular sales orders have become harder to find.
How can I go back to the previous sort order, and what are some of the problems I should consider?
Thank you....
- Reinhard
We migrated to SQL for version 4.0 SP3.
We have two types of sales orders, with number series SO-###### and SO-ENG######
ENG are engineering orders, we don't have that many. Before the migration, ENG orders were sorted before SO orders, so the last order in the list was the most recent actual order. After the migration, ENG orders are sorted after SO orders and regular sales orders have become harder to find.
How can I go back to the previous sort order, and what are some of the problems I should consider?
Thank you....
- Reinhard
0
Answers
-
SQL have different sorting order. This is a fact. And there is no way how to change that for your example. Because on SQL numbers are before characters...0
-
I think Mark Brummel did a presentation where this is possible, but it requires the use of temporary table and display the temporary table on the form.
Not a pretty solution and I suspect it'll net you more problems than benefits.Confessions of a Dynamics NAV Consultant = my blog
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions