Very Computer

I'd like to have the result of a parametrized Recordset with LockOptions set
to BatchOptimistic.

I've found that only the Command object has Parameters collection. The
Command.Execute method returns the recordset well, but it sets the
LockOptions property to adLockReadOnly.

With the Recordset object i can open a recordset with any LockOptions
setting but cannot pass Parameters since the Recordset object doesn't have
such thing.

I would be very grateful if somebody could give me a way-out from this
situation.

Attila

I could also use a Command object in the Recordset.Open function, which
works fine, but then i cannot disconnect the recordset by setting the
ActiveConnection property to NULL (this property is ReadOnly).

The question is:
How to create a parametrized, adLockUpdateBatch, Disconnected Recordset.

Thanks for any input,
Attila

Quote:

> I could also use a Command object in the Recordset.Open function,
which
> works fine, but then i cannot disconnect the recordset by setting the
> ActiveConnection property to NULL (this property is ReadOnly).

This ought to be the right way to go,  but the Recordset
ActiveConnection will be Null anyway. To make this syntax work
properly, you'd need to set up the Command object with its own
ActiveConnection property, prior to calling RecordSet.Open with an
empty ActiveConnection parameter.

I guess the way to disconnect it would then be to set the Command
object's ActiveConnection to Null - though I've never tried it.

Roger Morton