This is a multi-part message in MIME format.
------=_NextPart_000_0031_01C78C9D.2BF24400
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0032_01C78C9D.2BF24400"
------=_NextPart_001_0032_01C78C9D.2BF24400
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hola Ignacio,
Correcto. Es casi lo que dec=EDa...

Yo no uso este m=E9todo. Creo que en un recordset no tiene sentido =
hacer b=FAsquedas sobre un =EDndice.
Saludos,
Jos=E9 Luis Capel
"Ignacio Ortiz de Z=FA=F1iga" <
NoName@xailer.com> escribi=F3 en el =
mensaje news:[email=
46378eb8@ozsrv2.ozlan.local...]
46378eb8@ozsrv2.ozlan.local...[/email]
ADO Seek Method
------------------------------------------------------------ -------------=
-----
Complete Recordset Object Reference=20
------------------------------------------------------------ -------------=
-----
The Seek method searches the index of a Recordset to find a record =
that matches the values specified in the keyvalues parameter. If there =
is a match, the pointer will point to the record specified by the =
seekoption parameter. If there is no match, the record pointer will be =
placed at the end of the Recordset.=20
Note: To use this method, the provider must support this method and =
the use of indexes on a Recordset (the Index property). Use the Supports =
method to determine whether the provider supports seek and indexes.=20
Note: Set the Index property to the desired index before executing =
this method.=20
Note: This method can only be used with server-side cursors (not =
supported when the CursorLocation property value is adUseClient).=20
Note: This method can only be used when the Recordset object was =
opened with the CommandTypeEnum value of adCmdTableDirect. (es decir, =
acceso directo a la tabla, osea, nada que ver con cliente-servidor)
ADO Index Property
------------------------------------------------------------ -------------=
-----
Complete Recordset Object Reference=20
------------------------------------------------------------ -------------=
-----
The Index property sets or returns a string value that indicates the =
name of the current index for a Recordset object. The index must have =
been created as an index on the table or as an ADOX Index object. This =
property can be set on an open or closed Recordset.=20
Note: This property is used together with the Seek method to create an =
indexed display of records and to use the Seek method to search these =
indexed records, but few providers supports this property and method. =
Use the Supports method to determine whether the provider supports seek =
and indexes.=20
Saludos,
------=_NextPart_001_0032_01C78C9D.2BF24400
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hola Ignacio,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>Â</DIV>
<DIV><FONT face=3DArial size=3D2>Correcto. Es casi lo que =
dec=EDa...Â=20
:-)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>Â</DIV>
<DIV><FONT face=3DArial size=3D2>Yo no uso este m=E9todo. Creo que =
en un=20
recordset no tiene sentido hacer b=FAsquedas sobre un =
=EDndice.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>Â</DIV>
<DIV><FONT face=3DArial size=3D2>Saludos,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Jos=E9 Luis Capel</FONT></DIV>
<DIV>Â</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Ignacio Ortiz de Z=FA=F1iga" <<A=20
href=3D"mailto:
NoName@xailer.com">
NoName@xailer.com</A>> escribi=F3 =
en el=20
mensaje <A=20
=
href=3D"news:
46378eb8@ozsrv2.ozlan.local">news:
46378eb8@ozsrv2.ozlan.loca=
l</A>...</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>
<H1>ADO Seek Method</H1>
<HR>
<A href=3D"
http://www.w3schools.com/ado/ado_ref_re ... .asp"><IMG =
class=3Dnavup=20
alt=3D"Recordset Object Reference" =
src=3D"
http://www.w3schools.com/images/up.gif"=20
border=3D0> Complete Recordset Object Reference</A>=20
<HR>
<P>The Seek method searches the index of a Recordset to find a record =
that=20
matches the values specified in the keyvalues parameter. If there is a =
match,=20
the pointer will point to the record specified by the seekoption =
parameter. If=20
there is no match, the record pointer will be placed at the end of the =
Recordset. </P>
<P><B>Note:</B> To use this method, the provider must support this =
method and=20
the use of indexes on a Recordset (the Index property). Use the =
Supports=20
method to determine whether the provider supports seek and indexes. =
</P>
<P><B>Note:</B> Set the Index property to the desired index before =
executing=20
this method. </P>
<P><B>Note:</B> This method can only be used <FONT =
color=3D#ff0000><STRONG>with=20
server-side cursors</STRONG></FONT> (not supported when the =
CursorLocation=20
property value is adUseClient). </P>
<P><STRONG>Note:</STRONG> This method can only be used when the =
Recordset=20
object was opened with the CommandTypeEnum value of <FONT=20
color=3D#ff0000><STRONG>adCmdTableDirect</STRONG></FONT>. =
(<STRONG><FONT=20
color=3D#0000ff>es decir, acceso directo a la tabla, osea, nada que =
ver con=20
cliente-servidor)</FONT></STRONG></P>
<H1>ADO Index Property</H1>
<HR>
<P><A href=3D"
http://www.w3schools.com/ado/ado_ref_re ... .asp"><IMG =
class=3Dnavup alt=3D"Recordset Object Reference"=20
src=3D"
http://www.w3schools.com/images/up.gif" border=3D0> Complete =
Recordset=20
Object Reference</A> </P>
<HR>
<P>The Index property sets or returns a string value that indicates =
the name=20
of the current index for a Recordset object. The index must have been =
created=20
as an index on the table or as an ADOX Index object. This property can =
be set=20
on an open or closed Recordset. </P>
<P><B>Note:</B> This property is used together with the Seek method to =
create=20
an indexed display of records and to use the Seek method to search =
these=20
indexed records, <STRONG><FONT color=3D#ff0000>but few providers =
supports this=20
property and method</FONT></STRONG>. Use the Supports method to =
determine=20
whether the provider supports seek and indexes. </P>
<H3>Saludos,</H3>
<P><FONT face=3DArial =
size=3D2></FONT>Â</P></DIV></BLOCKQUOTE><FONT face=3DArial=20
size=3D2></FONT></BODY></HTML>
------=_NextPart_001_0032_01C78C9D.2BF24400--
------=_NextPart_000_0031_01C78C9D.2BF24400
Content-Type: image/gif;
name="up.gif"
Content-Transfer-Encoding: base64
Content-Location:
http://www.w3schools.com/images/up.gif
R0lGODlhEgAWANU/AGwMDP/+qvz0tf79+dirKvWjo9OjGO7o1uK2NdyvNv// w93AZ+vIVOxXV//7
lf/Wdu/cgdgYGJoREfnXbOfSkugrK6sTE+k9Pd+zPfz56v/+0v/gfP/0jevZ o9+0MMcWFu9tbbIU
FP/qhvXszOpERM6bBvLmvvjCwoUPD///5/Hy7vny2eLMhr8VFejcs+AZGeHG dOe8ROrhwvz53P/Y
gfTIYPnNcO7iv//tmf/11f/np8yZAc+dCf//////mf///yH5BAEAAD8ALAAA AAASABYAAAb/wJ9w
KAQBGsJej8j8nQAoQKigbBJbKEtIgiItrT+jJBT6tCSSgvU5Ln8irxagkvxi Q5bW5xVHRSMHGIIY
UBYWKHwvEl8/CR0zKRojMCoqAC0vFYtDCRo+nwodCQkVIRWajAkBn5+rn6YX EqMJNwkOt7gOHB4W
FyQSJiY9PAQ4IsfHEx4ZISQNEgMDJsQiGwwe2MsBIQ3PKSk8AwY0NTCRCgoB 2w0vERoCPD8GDx4r
rJ+lDSgQCjwHPzxsYNCQywEKEBIqiAiwQEiJGhQEcJjIoYIFCRE4bOAhQ8iO GCuQHZMwJ1k8jwly
bFi5MgKDGAR4GHAxZAcMHQ8mMEBgYAeBGQUU/hHZMcJDzwQsOgxgxGTHDhY0 h1SxEgQAOw==
------=_NextPart_000_0031_01C78C9D.2BF24400--
Attached files