CRecordset insert problem

[Bilge Kaan]

I have a stored procedure which inserts data to table and returns id of inserted data. When I tried to execute procedure using CRecordset open method , i got exception because recordsets can only do selection (readonly). But I saw that Addnew and Update methodes can be used to ınsert new data using recordset. Is there any workaround for open method to execute inserts?

[Rajesh R Subramanian]

Bilge Kaan wrote:

i got exception because recordsets can only do selection (readonly).

Take a look at the parameter dwOptions of CRecordset::Open[^]. I'm suspecting that you're probably opening it with CRecordset::readOnly flag, while you must be opening it with CRecordset::none or CRecordset::appendOnly (depending on your needs)

It is a crappy thing, but it's life -^ Carlo Pallini

[David Crow]

Have you seen this or this?

"Old age is like a bank account. You withdraw later in life what you have deposited along the way." - Unknown

"Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons