Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 297 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Change Column Data Type
leikelman
Member Posts: 31
I need to change the data type of a column in a table from Code(10) to Text(10). After changing the data type of the column I get the following error when trying to run reports/forms associated with the table:
The definition of column 'CostCentre' was changed after the object was saved.
Old Type: Code
New Type: Text
I found to fix this problem I need to go into each report and remove the Record global variable reference to the table and re-add it.
Is there some faster way of doing this? Is there any built in function to update all references linked to that table?
Thank you.
The definition of column 'CostCentre' was changed after the object was saved.
Old Type: Code
New Type: Text
I found to fix this problem I need to go into each report and remove the Record global variable reference to the table and re-add it.
Is there some faster way of doing this? Is there any built in function to update all references linked to that table?
Thank you.
0
Comments
viewtopic.php?f=23&t=28202
Regards