Transfer data from RecordRef to temp Record?

arcullarcull Member Posts: 191
edited 2009-08-07 in NAV Tips & Tricks
Hi. Does anyone know the way to transfer data from RecordRef variable to Record variable which is marked as temporary. Any suggestion much appreciated.

Comments

  • reijermolenaarreijermolenaar Member Posts: 256
    Hi,

    You can do this with the settable command.
    RecRef.SETTABLE(TmpRecord);
    

    To transfer all records to a temporary record you will have to make a loop:
    IF RecRef.FINDSET THEN
      REPEAT
        RecRef.SETTABLE(TmpRecord);
        TmpRecord.INSERT;
      UNTIL RecRef.NEXT = 0;
    
    Reijer Molenaar
    Object Manager
  • arcullarcull Member Posts: 191
    Excellent reijermolenaar =D>, many thanks for the hint. However there is still a little modification needed :), because when you execute RecRef.SETTABLE(TmpRecord), the filters set on RecRef get spoiled by the filters from TmpRecord and if TmpRecord has no filters on it, it's like doing a RESET on RecRef. Therefore the coding should look like:
    IF RecRef.FINDSET THEN BEGIN
      TmpRecord.SETVIEW(RecRef.GETVIEW);
      REPEAT
        RecRef.SETTABLE(TmpRecord);
        TmpRecord.INSERT;
      UNTIL RecRef.NEXT = 0;
    END;
    
    PS: To Admins, I suggest this to be put in Tips/Tricks section.
  • krikikriki Member, Moderator Posts: 9,094
    [Topic moved from 'NAV/Navision' forum to 'NAV Tips & Tricks' forum]
    arcull wrote:
    PS: To Admins, I suggest this to be put in Tips/Tricks section.

    PS: To Users, I suggest to use the reporting functionality (the red ! at the right of the post) to do that. :wink:
    I happened to read this, but we don't read ALL posts. With the reporting functionality we always notice it.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


Sign In or Register to comment.