Mass Change fields

gbdman1

Hello, I'm very new with microsoft nav 4.0 SP1 and i would to make a question

Is there a way to mass change a filed in a table? for example i would like to set all the General Ledger account to Inactive.

Thank you

kapamarou

Look up command MODIFYALL.

Savatage

Inactive? I have blocked if that's what you're talking about..

Anyway - you could use a report to update fields easily

example

onaftegetrecord;
blocked := true;
"G/L Account".modify;

or just run the G/L Account table from object designer, find the field you want to change and go down the list.

OR use find & replace on the table - doesn't work for boolean tho.

Alex_Chow

You can also use Find and Replace on the forms without going through the object designer.

I don't believe the Find and Replace works on boolean fields though... :-k