Re: Rowset position cannot be restarted error
- From: "Stephen Howe" <sjhoweATdialDOTpipexDOTcom>
- Date: Tue, 16 Aug 2005 00:12:16 +0100
>I want to open a recordset based on a SP but need to move forwards and
>backwards through the recordset. When I use the code below I get a forward
>only recordset.
Yes it will do. All Recordsets returned from a Command Object are read-only.
They are ForwardOnly if the default Cursor Location on the Connection is
Server-sided
They are Static if the default Cursor Location on the Connection is
Client-sided
A 2nd method has to be used.
> I have tried opening the recordset but this doesn't work.
"doesn't work" is a bad thing to say. Totally non-descriptive.
Everybody in response is going to say, "How doesn't it work? What are the
symptoms? Are there any error messages? If so, what?"
Nobody has any idea how it fails (does not compile, does not link, error
message at run time - (if so what?), etc).
As it stands you were on the right track. Opening the Command Object as
Recordset Source is correct. But
The Recordset's Connection property _must_ be UNspecified
The Command's Connection property _must_ be specified
The Recordset gets it's connection from the Command object.
Stephen Howe
.
- References:
- Rowset position cannot be restarted error
- From: Chris Kennedy
- Rowset position cannot be restarted error
- Prev by Date: RE: Oracle Computed column datatype
- Next by Date: Re: Rowset position cannot be restarted error
- Previous by thread: Rowset position cannot be restarted error
- Next by thread: Re: Rowset position cannot be restarted error
- Index(es):
Relevant Pages
|
|
