I want update one record using ADO,but I can't ,why?

N

nightmarch

I want update one record ,but I can't ,why?

code like following:

##-------------------------------------------------
import win32com.client as wc

def main():
conn = wc.Dispatch(r'ADODB.Connection')
rs = wc.Dispatch(r'ADODB.Recordset')
connStr = "Provider=MSDAORA.1;Password=jmpower;User
ID=jmpower;Data Source=jmgis_agps3;Persist Security Info=True"
tblName = r'wjtmp'

conn.Open(connStr )

rs.Open( tblName, conn, wc.constants.adOpenKeyset,
wc.constants.adLockOptimistic )

if rs.Supports( wc.constants.adUpdate ):
rs.Fields.Item(0).Value = 11
rs.Update()
else:
print "recordset can't update"

rs.Close()
conn.Close()

if __name__ == '__main__':
main()
##-------------------------------------------------


thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,780
Messages
2,569,611
Members
45,281
Latest member
Pedroaciny

Latest Threads

Top