When creating a business object there are properties for the Insert, Update, and Delete sprocs. Am I correct in the following assumptions...

• Save without a Primary Key sent through will use the Insert Sproc
• Save with a Primary Key sent through will use the Update Sproc
• DeleteByPrimaryKey will use the Delete Sproc

I looked through the help and the forum and hope that this isn't easily spelled out somewhere and I am missing it. Since my db will not have any reader/writer permissions, its important that I get this right from the start.

Thanks!

Clay

Thanks

To change the state for Add and Edit I assume it o.Add and o.Edit respectively. What is the command for Delete?

To add a new row, you can either call Add() or NewRow().  Add() calls NewRow() internally, but also changes the editing state of the business object to Adding, which updates the bound controls.  To change a record to Modified, you can call Edit(), or just set one of the field properties, which will change the data within the current row, and the row will automatically change state to Modified.  To delete a row, you can call DeleteCurrentRow() when you have the row you want to delete selected.  To delete a row that is not in the business object, you can also call DeleteByPrimaryKey() and pass the pk of the record you want to delete.