Diff between Recordset.update & insert cmd

mp3pm · September 1st, 2006, 11:47 AM

hi peeps
Could anyone plz explain the difference between update method of a recordset and insert into statement..cause iam trying to edit a row and then putting it back in the database.i get the error 3251 says current recordset doesnot support updating.this may be a limitation of the provider or of the selected locktype.
iam using sqlserver (works as it retrieves data into the fields)
CursorLocation = adUseClient
adOpenStatic, adLockOptimistic
recordset editmode is 0 ,how to change it to 1?
anything wrong ?here.
plz advice...
thanks.

gbianchi · September 1st, 2006, 11:53 AM

hi there... you open the recordset static... open it in another mode like adOpenDynamic...

HTH

Gonzalo

mp3pm · September 1st, 2006, 12:12 PM

Thanx for the reply mate
Still same problem..same error..

gbianchi · September 1st, 2006, 12:14 PM

mmm and if you change the cursor location to server???

HTH

Gonzalo

mp3pm · September 1st, 2006, 12:15 PM

Same Story mate..:(

ashu_from_india · September 1st, 2006, 12:38 PM

can u post ur connectionstring, connection open code also

woodyz · September 1st, 2006, 03:54 PM

How are you opening your recordset?
Are you using the RecordSet.Open method or the Connection.Execute method?

You must use the Recordset.Open method to get an updateable recordset.

There are other scenarios that will cause this situation.

Woody Z http://www.learntoprogramnow.com