I've a short questition. I want to remove all the Signs "Modified" at the Object Designer, because we relaunched the whole database and want to see which objects are modified since today.
Thanks for your help. I tried it, but I got the following error message:
"You cannot modify table data in the object table. Modify the table definition instead."
Do I need some special rights to get access to the table "Object"? We have the development licence. (Just an info: I become a developer. At this time I'm a blody greenhorn)
I've a short questition. I want to remove all the Signs "Modified" at the Object Designer, because we relaunched the whole database and want to see which objects are modified since today.
Is it possible to remove all marks at one time?
Wouldn't it be easier to put a filter on the Date-field when you need to know it?
Regards,Alain Krikilion No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Comments
Create a codeunit or a report over table 2000000001 and do:
Record.MODIFYALL(Field, NewValue [, RunTrigger]);
where:
Record.MODIFYALL(Modified, False);
Easy.
jpjesus@netcabo.pt
Ah, I see now that I was too slow... ;-)
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
"You cannot modify table data in the object table. Modify the table definition instead."
Any Idea?
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
:sick:
Create a Report and save it.
In the DataItem put in Object.
Go into the properties of the DataItem Object and add the following line into the DataItemTableView.
SORTING(Type,Company Name,ID) WHERE(Type=FILTER(Table..Codeunit),Modified=Const(Yes))
* This is in V3.70 so you might need to add the menusuite into your filter on the type e.g. (Table..MenuSuite)
Then on aftergetrecord of the DataItem write the following code.
Modified := FALSE;
MODIFY;
And the run.
Just Make sure that the report you design is within you license range.
Reg, Unnar
Thank you so much. It's working fine!
Have a nice day
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!