Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
Options
Fill in large scale
Rikarddo
Member Posts: 80
Imagine this scenario.
I have the contact table that contains a GUN field, flowfield, which looks for the UN in an X table,
and returns the responsible for this UN.
CACLFORMULA = Lookup ("Dimension Value". "Consolidation Code" WHERE (Dimension Code = CONST (UNEGOCIO), Code = FIELD (UN)))
However, I wanted the field to be filled without changing the current architecture of the table. So I created a GUN2 field that is populated every time a new contact is created. And I put this code in the UN - On Validate field
IF DimensionValue.GET ('UNEGOCIO', UN) THEN BEGIN
GUN2: = DimensionValue. "Consolidation Code";
MODIFY;
END;
My problem is that if I have 1000 contacts associated with that UN, I have to modify one by one, and I wanted to do the opposite. Change in the X table the responsible, forcing my new field in the contact table.
Any thoughts?
I have the contact table that contains a GUN field, flowfield, which looks for the UN in an X table,
and returns the responsible for this UN.
CACLFORMULA = Lookup ("Dimension Value". "Consolidation Code" WHERE (Dimension Code = CONST (UNEGOCIO), Code = FIELD (UN)))
However, I wanted the field to be filled without changing the current architecture of the table. So I created a GUN2 field that is populated every time a new contact is created. And I put this code in the UN - On Validate field
IF DimensionValue.GET ('UNEGOCIO', UN) THEN BEGIN
GUN2: = DimensionValue. "Consolidation Code";
MODIFY;
END;
My problem is that if I have 1000 contacts associated with that UN, I have to modify one by one, and I wanted to do the opposite. Change in the X table the responsible, forcing my new field in the contact table.
Any thoughts?
0
Best Answer
-
OptionsRikarddo
Member Posts: 80
I added this code but somehow not working
Consolidation Code - OnValidate()
IF "Consolidation Code" <> xRec."Consolidation Code" THEN
BEGIN
Contact.RESET;
Contact.SETRANGE(UN,Code);
IF Contact.FINDSET THEN BEGIN REPEAT
Contact.GUN2:="Consolidation Code";
MODIFY;
MESSAGE('Test');
UNTIL Contact.NEXT=0;
END;
END;
It shows the pop up message with Test, but the field in contact table is not being updated. What am i doing wrong?
Help? Thanks0
Answers
Consolidation Code - OnValidate()
IF "Consolidation Code" <> xRec."Consolidation Code" THEN
BEGIN
Contact.RESET;
Contact.SETRANGE(UN,Code);
IF Contact.FINDSET THEN BEGIN REPEAT
Contact.GUN2:="Consolidation Code";
MODIFY;
MESSAGE('Test');
UNTIL Contact.NEXT=0;
END;
END;
It shows the pop up message with Test, but the field in contact table is not being updated. What am i doing wrong?
Help? Thanks
My bad
Contact.Modify; //
IF Contact.FINDSET(TRUE) THEN REPEAT (Remove Begin and add TRUE on Findset Parameter)
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/