|
|
Tuesday, March 14th, 2006
|
3:19p - Gettind recordsets via ADO Command Object
Hi everyone.
...about programming MS ADO with MS SQL Server.
Is it possible to get a (ADODB) Recordset having NOT Forward-only cursor type from 'Execute' method of ADO Command object?
To be clear, in terms of VBA Code:
Dim adocmd as ADODB.Command
Dim rst as ADODB.Recordset
Set adocmd = New ADODB.Command
' ....... Connecting 'adocmd' via MS SQLOLEDB Provider
Set rst = adocmd.Execute
The problem is that I could not get non-ForwardOnly recordset in the last statement in all cases, and I wish to use the result (rst) as the data source (Recordset property) for a MS Access form. Such forms don't allow to set forward-only recordsets as form data sources, of course.
The parameters of 'Execute' method of ADODB.Command object do not include cursor type setting of the recordset returned.
Thanks in advance for any help.
UPDATED. A solution is found.
( Read more...Collapse )
(3 comments |comment on this)
|
|
|
|
