asp_databases thread: Filter or Find records from recordset!
Message #1 by Aftab Ahmad <aftab.ahmad@k...> on Fri, 5 Oct 2001 15:45:17 +0200
|
|
Hello
Please help me.
I am trying to use both above recordset properties but these do not work.
When I use the below syntex:
objRS.find "utligningsgruppenr = 21"
it gives error:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E29)
Rowset does not support scrolling backward.
regards
aftab
Message #2 by "Ken Schaefer" <ken@a...> on Mon, 8 Oct 2001 13:13:11 +1000
|
|
Change your cursor type to one that supports backward scrolling *or*, why
not restrict the resultset so that only the relevant record is returned in
the first place by using SQL rather than a recordset object containing the
whole table?
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Aftab Ahmad" <aftab.ahmad@k...>
Subject: [asp_databases] Filter or Find records from recordset!
: Please help me.
: I am trying to use both above recordset properties but these do not work.
:
: When I use the below syntex:
: objRS.find "utligningsgruppenr = 21"
:
: it gives error:
: Error Type:
: Microsoft OLE DB Provider for SQL Server (0x80040E29)
: Rowset does not support scrolling backward.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #3 by David Cameron <dcameron@i...> on Mon, 8 Oct 2001 10:15:51 +1000
|
|
Check the options that you have opened the recordset under. Try
adopenstatic.
regards
David Cameron
nOw.b2b
dcameron@i...
-----Original Message-----
From: Aftab Ahmad [mailto:aftab.ahmad@k...]
Sent: Friday, 5 October 2001 11:45 PM
To: ASP Databases
Subject: [asp_databases] Filter or Find records from recordset!
Hello
Please help me.
I am trying to use both above recordset properties but these do not work.
When I use the below syntex:
objRS.find "utligningsgruppenr = 21"
it gives error:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E29)
Rowset does not support scrolling backward.
regards
aftab
Message #4 by Aftab Ahmad <aftab.ahmad@k...> on Mon, 8 Oct 2001 08:54:41 +0200
|
|
Thanks
Now it's working
aftab
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: 8. oktober 2001 05:13
To: ASP Databases
Subject: [asp_databases] Re: Filter or Find records from recordset!
Change your cursor type to one that supports backward scrolling *or*, why
not restrict the resultset so that only the relevant record is returned in
the first place by using SQL rather than a recordset object containing the
whole table?
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Aftab Ahmad" <aftab.ahmad@k...>
Subject: [asp_databases] Filter or Find records from recordset!
: Please help me.
: I am trying to use both above recordset properties but these do not work.
:
: When I use the below syntex:
: objRS.find "utligningsgruppenr = 21"
:
: it gives error:
: Error Type:
: Microsoft OLE DB Provider for SQL Server (0x80040E29)
: Rowset does not support scrolling backward.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
View Cart
