changing data in a table with a batch
                
                    JBeck                
                
                    Member Posts: 68                
            
                        
            
                    Hi,
I was wondering if I could manipulate de data of a table with a batch.
e.g. can I multiply the amount with a factor?
Thanks in advance
J.Beck
                I was wondering if I could manipulate de data of a table with a batch.
e.g. can I multiply the amount with a factor?
Thanks in advance
J.Beck
0                
            Comments
- 
            You could create a report or a CodeUnit to do this kind of thing ...
What do you want to do exactly ? Are you End User or Nav partner ?0 - 
            I'm an Nav programmer.
I've already created a codeunit for this but it doesn't have any effect.
I'm trying to multiply the amount with a thousand.
The code looks like this:grootboekpst.SETCURRENTKEY(grootboekpst.Nr); grootboekpst.SETFILTER(grootboekpst.Boekingsdatum, '%1..', begindat); IF grootboekpst.FIND('-') THEN BEGIN REPEAT grootboekpst.Amount := grootboekpst.Amount * 1000; UNTIL grootboekpst.NEXT = 0; END;0 - 
            What about saving the modification through .MODIFY??? ;-)0
 - 
            Of course #-o .....
Thanks a lot!!!!!
                        0 
Categories
- All Categories
 - 73 General
 - 73 Announcements
 - 66.7K 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
 - 323 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
 
