Sorry, I mean this code line " rs.Supports( wc.constants.adUpdate ) " got False result, So I can't update one record,i.e. I can't execute this code "rs.Fields.Item(0).Value = 11".
And , if code is written like this: ##<code------------------------- conn.Open(connStr ) rs.Open( tblName, conn, wc.constants.adOpenKeyset, wc.constants.adLockOptimistic ) rs.Fields.Item(0).Value = 11 s.Update() ##>code------------------------- I got error msg like following: ##<errorMsg---------------------------- self._oleobj_.Invoke(*(args + (value,) + defArgs)) com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3', (0, 'ADODB.Field', 'Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.', 'C:\\WINNT\\HELP\\ADO210.CHM', 0, -2146825037), None) ##>errorMsg---------------------------- On Tue, 25 Jan 2005 10:25:00 -0800, Robert Brewer <[EMAIL PROTECTED]> wrote: > nightmarch wrote: > > 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() > > ##------------------------------------------------- > > You almost give us enough information to help out ,but you don't quite > ,why? > > What happens when you run the above? Is there any output? Error message? > > Does your update affect the membership of the record in the keyset? > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/ > htm/mdconkeysetcursors.asp > > Why are you using keysets at all? > > > Robert Brewer > MIS > Amor Ministries > [EMAIL PROTECTED] > -- http://mail.python.org/mailman/listinfo/python-list
