Dear Sir

As the form bind by a BO, I will able to retrieve all the records from BO.filldatatable. But when I use navigation button to edit several records, I encounter that only the first record is amend, the else will be remain unchanged after my form close and reopen again. FYI, this form will have no problem if I only append new record even to several new record.

Kindly enlighten me

Andrew

Hi Andrew.

It could be easier if you published a sample of what you are doing, so we could have a deeper understanding of what is happening. Maybe you could also have a look at the AcceptRowChangesMode property at the BusinessLayer and see if that could help you.

Hi Ivan,

I did tried to set AcceptRowChangesMode to acceptaftertablesaved but it's not work.
Let me further explain from my friend's question. when i try to edit and save several record on same form, only the first edited record is saved into database but subsequent records aren't saved. It seems the subsequent record edited doesn't flag dirty the Isdirty property. How do i to solve it up ivan.


Thanks

Hey Tiong!

It is a bit difficult for me to really know what could be happening without looking at the code, that is why a sample could help. But have a look at the Save on the help, you basically have the Form Save and the BO Save. When you are navigating, are you taking care of the possible Broken Rules. Check the "Saving Data" under "Application Framework" / "Business Layer" / "Common Business Object Taks" / "Saving Data" help topic.

Cheers.

Hi Tiong.

I had a look at it and it worked just fine! I added new records to your Module/Home/Setup/A - F/Action, and saved them. All OK.

Then I went back to the same form, it came already populated, made changes and saved one by one, no problem either. All of them were saved back to the underlying table.

Hi Ivan,

Have you create and edit more than one records? I create 3 action record and close the form. Then i open the action form again edit all 3 action records but only the first record edited update into database.

Please advice


Thanks

Well, this is exactly what I did and the 3 of them saved perfectly. Really hard to give you some advice with what I have in hands over here, it just works.

Hi Ivan,

I did tried again drop my database and regenerate again with my sql scripts. After i test edit records again and it's work fine.

Thanks Ivan for you precious time spent

You are welcome, Tiong.

Glad you got it going.