ADODB.RecordSet bummer ( was Re: Python and DB support (was: Re: Is Python Dead?))
BPettersen at NAREX.com
Wed Jul 4 01:38:15 CEST 2001
> From: Bill Bell [mailto:bill-bell at bill-bell.hamilton.on.ca]
> [Martelli's address not included since many list members may
> already know it.]
> Alex Martelli wrote, in part:
> > you CAN write rs.Fields("FieldName").Value ... [and] ... I believe
> > ADO (and much more so, COM:-) deserves a far better language than
> > Visual Basic... Python, for example!-).
> Yup, me too FWIW. So, as one of this list's most longstanding
> newbies, I decided to give the combination a spin.
> In VBA it's common to coin the cliche:
> with myRecordSet
> .fields('myField') = 42
> end with
> >>> import win32com.client
> >>> rs = win32com.client.Dispatch("ADODB.RecordSet")
> >>> rs.ActiveConnection = "DSN=WebPASS"
> >>> rs.Open("[URLs]")
> >>> rs.Fields("myField") = 42
> Traceback (SyntaxError: can't assign to function call
> Or, is this because I forgot my medication this morning?
rs.Fields("myField").Value = 42
More information about the Python-list