Home Original page

question about COM and ADO

Bill Tutt billtut at microsoft.com
Tue Feb 1 15:10:57 EST 2000 
> -----Original Message-----
> From: gtalvola at NameConnector.com [mailto:gtalvola at NameConnector.com]
> 
[problems with translating the below VB code into Python]
> > >     Dim cnn as New ADODB.Connection
> > >     cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data
> > Source=c:\db1.mdb"
> > >     dim rs as New ADODB.Recordset
> > >     rs.CursorLocation = constants.adUseClient
> > >     rs.Open "SELECT * FROM Table1", cnn, adOpenStatic,
> > > adLockBatchOptimistic
> > >     set rs.ActiveConnection = Nothing

Well according to build.py:
		# This is not the best solution, but I dont think there is
		# one without specific "set" syntax.
		# If there is a single PUT or PUTREF, it will function as a
property.
		# If there are both, then the PUT remains a property, and
the PUTREF
		# gets transformed into a function.
		# (in vb, PUT=="obj=other_obj", PUTREF="set obj=other_obj
So, something like the following might work since, ActiveConnection does
have a put and a putref functions:
rs.SetActiveConnection(None) 

This code in Python
rs.ActiveConnection = None 
Has the bogus VB equivalent of:
rs.ActiveConnection = Nothing 
(i.e. no Set)

The PUT vs. PUTREF distinction royally sucks.

Bill
More information about the Python-list mailing list