Validate all table Filds

Business Central/NAV Developers Forum
1

I would like to use the validate function for a table. Is it possible.

Until now I validate field by field

2

From C/AL there is no other way then you do right now. In general it would not make sense to validate all fields at once as many valitdation code (for various fields) are linked to/entangled which each other.

3

what do you want to do in that VALIDATE?

4

I created a New Flowfiel(RecSum) in PurchaseLines that sums all my Quantity Line type= Item.

On the same Order Purchase Record, I will have a Resourse Type line that on Quantity Field will have the RecSum Value.

For that, I am doing This, but I have to Validate all My PurchaseLine fiels, one by one

On

Form - OnAfterGetCurrRecord()
CurrForm.UPDATECONTROLS;

IF Type = Type:: Resource THEN BEGIN
VALIDATE(Quantity);
Quantity := RecSum;
“Qty. to Receive” :=RecSum;
“Qty. to Invoice” := RecSum;

END

5

Is this FlowField on the Purchase Line table (39) or on the Purchase Header table (38)? How does it’s CalcFormula look like?