Deleting data in a field

Business Central/NAV Developers Forum
1

Dear friends, Can anybody tell me how can i delete easily(Not thru C/AL code) the total data of a perticular field in all records of the table ??? Regards, Rajasekhar Venumala

2

Hi, There is no direct way to delete data from a field.

3

The above holds good, but a simpler approach can be by creating a report(not saving it) and putting 2 lines of code to do the job. DataItem.Field:=’ '(or 0); DataItem.MODIFY; and run the Report.

4

Hi! You could use the Search/Replace-Funktion of NAVISION [8D] (without C/AL code!) if the field-value is the same in all records. Just replace the value with ‘’ or 0 (depending on the datatype). Regards, Jörg

5

But don’t forget to check “replace whole field” or it won’t work…

6

I got what i need (But deleting thru code is easy thing it seems) Regards Rajasekhar Venumala

7

myrecord.SETFILTER(Field1,Value1); myrecord.SETFILTER(Field2,Value2); … if (myrecord.FIND(’-’)) THEN myrecord.MODIFYALL(field3,Value3); // if value3 = the empty value… then :slight_smile: Regards/