Re: Command object and non forward only recordsets.
From: "Stephen Howe" <sjhoweATdialDOTpipexDOTcom>
Date: Thu, 29 Dec 2005 00:23:36 -0000
> Does anyone know how to open a stored procedure using the command object > using anything other than a forward only recordset. Sometimes I need to do
> stuff that involves more than forward only movement.
Don't do
pRecordset = pCommand.Execute
You will either get
Server-sided, Forward-only, Read-only cursor if Connection CursorLocation is
Server
Client-sided, Static-only, Read-only cursor if Connection CursorLocation is
Client
Instead
1. Setup Recordset properties, but _NOT_ connection (needs to be null or
unset)
2. Setup Command properties and set connection (needs to be set)
3. Do
Re: Command Oject to pass parameters and CursorLocation ... recieved any results in my recordset.... The Cursor location for RecordSet returned is whatever the current Cursor ... Location of the underlying Connection for Command object is set to. ... DO NOT set Connection.... (microsoft.public.data.ado)
Re: Command Oject to pass parameters and CursorLocation ... recieved any results in my recordset.... The Cursor location for RecordSet returned is whatever the current Cursor ... Location of the underlying Connection for Command object is set to. ... DO NOT set Connection.... (microsoft.public.data.ado)
Re: Command Oject to pass parameters and CursorLocation ... recieved any results in my recordset.... The Cursor location for RecordSet returned is whatever the current Cursor ... Location of the underlying Connection for Command object is set to. ... DO NOT set Connection.... (microsoft.public.data.ado)
Re: reusing command object ... the recordset and make updates to certain records. ...Dim cmd As New ADODB.Command ...Dim rst As ADODB.Recordset ...command object as its connection parameter. ... (microsoft.public.access.adp.sqlserver)
Re: HELP! Error on Stored Procedure - AbsolutePage Property ... > "Current Recordset does not support bookmarks. ... > 'Connect command object to database (as I understand how you said to do ...SQL Server is a very capable provider, ... Of course all of this assumes the underlying SQL (in the stored procedure) ... (microsoft.public.vb.database.ado)
