Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-14 : 10:43:17
|
| Dennis writes "Is it possible to use the seek method down a SQL Server Table? I have tried it and it is saying that the provider doesn't support the index property. I am using VB.NET and MDAC 2.7 SP1. SQL SERVER 2000 Developer with SP2. WINDOWS XP Professional SP1a" |
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2003-05-23 : 11:15:24
|
| You didn't specify what type of cursor you are using. You are not actually attempting to seek on a table, but rather on a recordset based on an underlying table. Check the Supports property of your recordset, if it supports adIndex and adSeek. The syntax is : If rs.Supports(adIndex) = True ....You might have to experiment with cursor types (Keyset, Static, Dynamic) until you find one that supports Seek, unless you can do without it by using the Find method. It is also possible that the underlying table is not indexed properly, or that you are not retrieving all fields that are part of an index.Sarah Berger MCSD |
 |
|
|
|
|
|
MDAC 2.7 and Seeking on an SQL Server 2000 DB