Forum

Search UsersRules

Can not change the information register data

Kasih Ratu

Dec 03, 2012 03:28 PM

Just came

Points:: 0
Joined:: Oct 8, 2012

Salam!

I am trying to update some attributes in the information register while others should stay unchanged. I use the RecordSet for that, but somewhy the previous data is deleted when I write the RecordSet. Here is what I do:

Code

   RecordSet = InformationRegisters.ItemData.CreateRecordSet();
   RecordSet.Filter.Item.Set(CurrentItem);
   For Each Record In RecordSet Do
      Record.ModifiedAt = CurrentDate();
      Record.ModifiedBy = Ref;
   EndDo;
   RecordSet.Write();

Profile

ivan avdonin

Dec 03, 2012 03:31 PM

Active user

Points:: 0
Joined:: Sep 26, 2012

You need read records after filter on recordset sets
change to:

Code

RecordSet = InformationRegisters.ItemData.CreateRecordSet();
RecordSet.Filter.Item.Set(CurrentItem);
RecordSet.Read();
For Each Record In RecordSet Do
   Record.ModifiedAt = CurrentDate();
   Record.ModifiedBy = Ref;
EndDo;
RecordSet.Write();

Why so?
When write recordset without reading before, the empty recordset will be writing with filtering. Its like remove records with some filter.

Profile

Kasih Ratu	#3 Dec 03, 2012 04:32 PM
Just came Points:: 0 Joined:: Oct 8, 2012	Understood, thank you!
	Profile

Users browsing this topic (guests: 1, registered: 0, hidden: 0)