Transfer data from RecordRef to temp Record?

arcull
arcull 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

  • reijermolenaar
    reijermolenaar 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
  • arcull
    arcull 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.
  • kriki
    kriki Member, Moderator Posts: 9,121
    [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!

Categories