TRANSFERFIELDS function
tihomirjur
Member Posts: 21
Hi,
I'm using this function to do following:
I have 2 tables with same field IDs and data types but destionation table doesnt have 1 field that the source table has (it's a field from primary key in source table). I read the help file about this function. It says the following:
"...If the InitPrimaryKeyFields parameter is set to false, the TRANSFERFIELDS function will not change the timestamp or the Primary Key fields of the destination record.
If the InitPrimaryKeyFields parameter is set to true, and the records are in the same table, the TRANSFERFIELDS function will change both the timestamp and the Primary Key fields of the destination record.
If the InitPrimaryKeyFields parameter is set to true, and the records are not in the same table, the TRANSFERFIELDS function will change the Primary Key fields of the destination record (if the fields fulfill the conditions specified above) but the timestamp of the destination record will not be changed."
The default value of the parameter InitPrimaryKeyFields is TRUE. My case is displayed in red.My question is: What is timestamp? WHat does it mean that it will change the Primary Key fields of the destination record (because for example posting from Sales Header to Sales Shipment Header uses Transferfields without optional parameter and it seems to me it doesnt change the Primary Key fields)?
I'm using this function to do following:
I have 2 tables with same field IDs and data types but destionation table doesnt have 1 field that the source table has (it's a field from primary key in source table). I read the help file about this function. It says the following:
"...If the InitPrimaryKeyFields parameter is set to false, the TRANSFERFIELDS function will not change the timestamp or the Primary Key fields of the destination record.
If the InitPrimaryKeyFields parameter is set to true, and the records are in the same table, the TRANSFERFIELDS function will change both the timestamp and the Primary Key fields of the destination record.
If the InitPrimaryKeyFields parameter is set to true, and the records are not in the same table, the TRANSFERFIELDS function will change the Primary Key fields of the destination record (if the fields fulfill the conditions specified above) but the timestamp of the destination record will not be changed."
The default value of the parameter InitPrimaryKeyFields is TRUE. My case is displayed in red.My question is: What is timestamp? WHat does it mean that it will change the Primary Key fields of the destination record (because for example posting from Sales Header to Sales Shipment Header uses Transferfields without optional parameter and it seems to me it doesnt change the Primary Key fields)?
0
Comments
-
The timestamp is an internal field that is used to control the version of the record.
Meaning : if you copy also the timestamp, the destination record will have the same version as the source record.Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
Kriki, thanks for the timestamp explanation. Now i need answer to my other question!!:D0
-
In case of transferring to Sales Shipment Header, key ("No.") is changed later in code.
I never use InitPrimaryKeyFields...0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions