Howdy, Stranger!
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
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Remove Forbidden Characters Help!
HelpMePlease
Member Posts: 6
Hi fellow NAV developers.
I have to recently used Remove Excel CR+LF Errors from the Downloads section and imported it into my NAV DB.
Been struggeling awhile to get to only scan one entire table (18 - Customer table ). Please Help!
I have attempted to add a basic: TableScanList.SETRANGE(TableScanList.TableNo,18);
into the Codeunit (50004 - RemoveForbidenChars).
Added the statement about 3 times in the Codeunit. Aswel as dashing (//) out the these lines in 2 places on the codeunit:
TableScanList.SETFILTER(Type,'%1|%2',TableScanList.Type::Text,TableScanList.Type::Code);
TableScanList.SETRANGE(RelationTableNo,0);
All help will be appreciated. Kind Regards.
I have to recently used Remove Excel CR+LF Errors from the Downloads section and imported it into my NAV DB.
Been struggeling awhile to get to only scan one entire table (18 - Customer table ). Please Help!
I have attempted to add a basic: TableScanList.SETRANGE(TableScanList.TableNo,18);
into the Codeunit (50004 - RemoveForbidenChars).
Added the statement about 3 times in the Codeunit. Aswel as dashing (//) out the these lines in 2 places on the codeunit:
TableScanList.SETFILTER(Type,'%1|%2',TableScanList.Type::Text,TableScanList.Type::Code);
TableScanList.SETRANGE(RelationTableNo,0);
All help will be appreciated. Kind Regards.
0
Comments
I did not look at the code of this download, but your commenting out the two lines is questionable.
The first one is to make sure, you only modify text fields, not any binary fields, which would leave you with total gibberish.
The second one is to make sure you don't break any relations. You should only use this if you process all tables.