>Hi Charles,
>
>Let me present a specific example of what I want to do.
>
>On a single form (a maintenance form for example) using a single business object and a single table, I want to retrieve 3 related records. I want to edit record 1 and then navigate to record 2. I do NOT want to be prompted to save the changes I made in record 1 and I do NOT want those changes automatically saved. I then want to delete record 2 and then navigate to record 3 with no "Save Changes?" prompt. After viewing record 3 but without editing it al all, I want to create a new record 4. Then I want to save all the changes I made to all 4 records all at one time and all wrapped in a single transaction.
>
>Sam

That's not a problem at all. Remember this is a disconnected dataset ( ado ) so when you "save" you can save to the underlying cursor, but not update to the backend until your ready to commit all table changes in one transaction. You can also wrap you child change/new records etc in that transaction (or, if you like in a seperate transaction to be committed after the parent succeeds etc.; You can certainly navigate within the local cursor without committing anything - i.e. leaving the buffer dirty. The business object is really sophisticated and I think you'll be amazed at the level of control you have. And also remember this is even driven so when things happen an event is raised and you have the chance to intervene at pretty much every stage of the process by how you handle the event.

Here's another answer on the forum form Dustin Taylor :

"The short answer is yes, you can edit multiple records in a BO before saving the business object. It will keep track of which records within the BO are modified/added/deleted and, when a save is triggered, will take the appropriate action for each row. As Edhy mentioned, this can be inside or outside of a database transaction (StrataFrame provides methods to begin, rollback, and commit a Transaction as necessary), and will handle child records (along with all of the associated foreign keys) for you! "


>
>>Sam - here's the first answer to roll in from one of the long-time users on the forum
>>
>>"Yes everything is supported out of the box. Let me give you an example:
>>
>>You can have a form with a many Business Objects as you want, related in a any way you want and be able to save them all in a single transaction or in several transactions or some within transactions and others not or any combination you could imagine to create.
>>
>>StrataFrame does not require the parent record to be saved in order to create multiple children or grand children records. When a new record is created the PK value for the first one will be -1 and this value will be propagated to the related tables FK, so when saved it will update all with the auto-incremented value from the database. Also if you save a child business object which the parent has not been saved, StrataFrame will save all parent tables to ensure the reliability of the Primary/Foreign Key assignments.
>>
>>StrataFrame is so flexible in that you can create forms as those in MS OutLook to handle a single transaction per form, so in the case of accounting you can have a form to do a debit/credit transaction for a single customer and if you need to work on another customer you can just create another instance of the form with another customer record.
>>
>>PS
>>Of course the term "Out of the Box" does not mean that the developer does not have to program the logic required by the application's business rule [BigGrin] we have to do something besides using StrataFrame [Hehe]"
>>
>>I should be hearing from Trent Taylor tomorrow.
>>
>>
>>
>>
>>>I am just beginning to investigate Strataframe and I have a specific question. I would appreciate an answer from anyone who might know the correct answer. I am not prepared to signup for their free trial yet and I don't think I can post questions on their user forum.
>>>
>>>The frameworks I have worked with in the past seem to be designed expecting that I will be editing one record at a time from a given table. If I attempt to add or edit another record in the same table without saving the first record I edited, I am forced to either save the changes or abandon the changes before I can move to and edit another record.
>>>
>>>I am a CPA and I need to be able to add or edit multiple debit and/or credit transactions and then save all of them wrapped in a single backend transaction. Does Strataframe allow this right out of the box?
>>>
>>>Sam