How do you easy add or update a recordset when you have opened it using a stored procedure?
I'm making a program where the user sees a recordset as a grid (used SP). The user can edit rows or add new ones by going into detail mode. (I use a tabstrip where Grid is on the first and a detail frame is on the second tab.) When user goes into editmode I want the user to manipulate the record and be able to update or add.
But it seems that SP only return readonly recordsets. Is that so?
How do one then implement the grid/detail scenario when using stored procedures?
Examples are preferred!!
regards
Svein Are Gronsund, Norway