Can't modify the records

Business Central/NAV Developers Forum
1

I have a problem : When I filter the field (in codeunit), then I can’t modify this field in the table How can I solve this problem and change the records, which I filter? Or it is impossible Thank you

2

Hi Polina Perhaps do you want to modify a primary key field? Try it with a second record variable. Here you will find an example: http://www.navision.net/forum/topic.asp?TOPIC_ID=5798&SearchTerms=key bye Andre

3

I think what she’s is asking it’s something similar to this: Let’s say your record it’s recordA, just make a new variable type record (lets say recordB) and do as follows: RecordA.setrange(field01,filtervalue); if (recordA.find(’-’)) then repeat recordb.reset; recordb := recordA; recordb.field01 := value2; recordb.modify; until (recorda.next = 0);

4

or this : filter := 'Amsterdam'; newvalue := 'Den Haag'; foo.SETRANGE(bar, filter); WHILE foo.FIND('-') DO BEGIN foo.bar := newvalue; foo.MODIFY; END;