Transfer data from RecordRef to temp Record?

arcull

Hi. Does anyone know the way to transfer data from RecordRef variable to Record variable which is marked as temporary. Any suggestion much appreciated.

reijermolenaar

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;

arcull

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

[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.
I happened to read this, but we don't read ALL posts. With the reporting functionality we always notice it.