StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Mechanism to update a single row in a BO?

Mechanism to update a single row in a BO?

Greg McGuffey — Tue, 11 Dec 2007 09:47:23 GMT

I find myself occasionally needing to update a single record within a BO, usually after messing with data via a sproc. Is there any way to update just one record (row) in the BO?

RE: Mechanism to update a single row in a BO?

Trent L. Taylor — Tue, 11 Dec 2007 09:47:23 GMT

Yes. When tables are merged it goes through the ChangeCurrentDataTable method which ultimately raises the CurrentDataTableRefilled event.

RE: Mechanism to update a single row in a BO?

Robin J Giltner — Mon, 10 Dec 2007 09:09:01 GMT

Does the AppendDataTable fire the CurrentDataTableRefilled Event ?

Thanks,

Robin Giltner

RE: Mechanism to update a single row in a BO?

StrataFrame Team — Mon, 10 Dec 2007 08:52:02 GMT

Aha, that makes more sense :) You can use the AppendDataTable method and pass the query that will only retrieve that one record (we don't have an AppendByPrimaryKey). The other argument for the AppendDataTable() method, besides the DbCommand, is an enum that specifies whether to overwite duplicate records or keep duplicate records; you want to overwrite the record.

RE: Mechanism to update a single row in a BO?

Greg McGuffey — Fri, 07 Dec 2007 11:09:25 GMT

Oops, you misunderstand. How do I refresh that single data row with data from the database?

RE: Mechanism to update a single row in a BO?

StrataFrame Team — Fri, 07 Dec 2007 09:04:05 GMT

Well, if it's the only DataRow in the BO that is not Unchanged (modified), then it will be the only row that is saved. Otherwise, you would need to create a new business object, filter the current one down to that record, use MergeDataFrom to copy over the record, and save the new business object with just that one record in it.