|
Subject:
|
Diff between Recordset.update & insert cmd
|
|
Posted By:
|
mp3pm
|
Post Date:
|
9/1/2006 11:47:07 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.
|
|
Reply By:
|
gbianchi
|
Reply Date:
|
9/1/2006 11:53:06 AM
|
hi there... you open the recordset static... open it in another mode like adOpenDynamic...
HTH
Gonzalo
|
|
Reply By:
|
mp3pm
|
Reply Date:
|
9/1/2006 12:12:08 PM
|
Thanx for the reply mate
Still same problem..same error..
|
|
Reply By:
|
gbianchi
|
Reply Date:
|
9/1/2006 12:14:03 PM
|
mmm and if you change the cursor location to server???
HTH
Gonzalo
|
|
Reply By:
|
mp3pm
|
Reply Date:
|
9/1/2006 12:15:55 PM
|
Same Story mate..:(
|
|
Reply By:
|
ashu_from_india
|
Reply Date:
|
9/1/2006 12:38:33 PM
|
can u post ur connectionstring, connection open code also
|
|
Reply By:
|
woodyz
|
Reply Date:
|
9/1/2006 3:54:22 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
|
