hy everybody,
when i use findset(true,true) i ask the system, that i will rename the primary key fields. Now my question. For which Pk is this :?:
The primary Navision Key (Key 1) or the clustered key for the sql server :?:
Regards
Do you make it right, it works too!
0
Comments
When using FINDSET(TRUE,TRUE), you specify you will modify the currentkey. This could be the primary key, but it could be one of the secondary keys as well... .
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
RIS Plus, LLC
MVP - Business Apps
I read somewhere that you can also use FINDSET(FALSE,FALSE) and do it and it will work well, but it will be less efficient.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
In smaller loops I don't really think it will make much of a difference, but in larger ones it might. I'd say start out with the easy one and if you have performance issues you introduce more complexity.
RIS Plus, LLC
MVP - Business Apps
take a look on my code. i can't understand what is wrong...
i get an error on LProdOrderLine2.MODIFY saying that the record doesn't exist.
help please!
thanks in advance[/code]
don't use modify, use "rename" for that...
Modify tries to modify a record BASED on a primary key ... which you changed, so it doesn't exist
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog
/nod
:-k
Dictionary:
to express or signify by such a movement of the head: to nod approval; to nod agreement.
So I guess you agree
Eric Wauters
MVP - Microsoft Dynamics NAV
My blog