On Wednesday, August 28, 2002 at 17:20, Hoenig, Robert wrote:
HR> strSql = "Select * From tblproapp_cat where esnum = '" & strES & "' AND
HR> revnm = '" & strRevision & "'"
HR> set rsItem = CreateObject("ADODB.Recordset")
HR> rsItem.Open strSql, strconn, adOpenKeyset, adLockPessimistic, adCmdTable
you might be able to get away with a forward only cursor if you don't need
to move backwards, and don't you want adCmdText instead of adCmdTable??
HR> When trying to update the record (and 1 record does exist I checked what it
HR> was returning) I get the following error.
if you've looped through the recordset to display the results, you might
need to go back to the record you want to edit. you also need to make sure
you call rsItems.Update after you've made the changes to commit them.
though if you're updating the database, why not use an update sql string
and execute it??
hth,
darren.
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: archive@jab.org
To unsubscribe send a blank email to [EMAIL PROTECTED]
