Dynamics Community Forum Thread Details

Validate post code of contacts

Hi All

I have contacts inserted in table ID 5050 - Contact. And I have updated table 225 - Post Code and now I want to validate field: Post Code on Table Contact.

I tried to use Rapid package to first export all records with all fields and I get error File is to large, thus export to Excel fails.

I am trying to write a processing report that will read all the values inserted on field: Post Code from table Contact and validate field: Post Code.

ContactRec.GET("No.");
PostCodeRec.SETFILTER(PostCodeRec.Code,ContactRec."Post Code");
 IF PostCodeRec.FINDFIRST THEN BEGIN
  CurrFieldNo := ContactRec."No.";
  "Post Code" := ContactRec."Post Code";
  City :=PostCodeRec.City; //V1
  County :=PostCodeRec.County; //V1
  CountryCode :=PostCodeRec."Country/Region Code"; //V1
  PostCodeRec.ValidatePostCode(City,"Post Code",County,"Country/Region Code",(CurrFieldNo <> '0') AND GUIALLOWED);
END;

It does find correct records and it fills them as expected, but after validating is done, it does not commit values on the appropriate fields of Contact table.

How would you validate a value of a field for all records in a table where field that has to be validated already has inserted values as expected.

Thank you, Damjan

Quick Links