by René H. Pére » Wed, 16 May 2001 02:14:51
I tried with command object, but a error message indicate that sql ole
provider cannot support it.
What Can I do?
--
Ren H. Prez
El Salvador, Centroamerica
by René H. Pére » Wed, 16 May 2001 04:14:58
Quote:> How Do I make a parametrized Recordset. I am using SQL SERVER 7.0, VB 6.0,
> MDAC 2.6.
> I tried with command object, but a error message indicate that sql ole
> provider cannot support it.
> What Can I do?
> --
> Ren H. Prez
> El Salvador, Centroamerica
1. How to get a parametrized, non-ReadOnly Recordset?
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
2. IE4.5 automatically loads when emailing from Filemaker
3. how to -- parametrize ORDER BY in a stored procedure
4. WAREZ
6. Checking for previous BDE installation/Configuration, from my setup program.
7. ODBC Parametrized queries problem : parameter in where clause that can be NULL
10. PARAMETRIZED IN CLAUSE IN A QUERY
11. how to used a parametrized IN clause?
13. Parametrize Cursor declaration