Hi & Thanx for your reply & help.

But the problem is when i am using DSN it errors that record set doesn't 
support index property.

What should i do when i want to use seek on SQL Server database.

Thanx & Best regards.



>From: Dave Nguyen <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: Re: [vbhelp] About Seek Method
>Date: Tue, 8 Jun 2004 16:46:15 -0700 (PDT)
>
>Hi,
>
>Seek can be use when you connect to a DB table, using the following method:
>
>1.  rs.Index = "INDEX_NAME"
>2.  rs.seek "=", COMPARE1, COMPARE2
>
>3.  if rs.nomatch = TRUE then
>
>4.  End if
>
>Where:
>
>1.  you have to specify the name of the INDEX (if already created, in the 
>design mode of the DB)
>2. Seek "=" is to search for the matching record, where COMPARE1 and 
>COMPARE2 are the number of field  you use in your INDEX.  (In this case, 
>your Index contains 2 fields)
>
>3.  If rs.nomatch = False, it does not find any matches.
>
>Hopes this helps
>
>
>
>Salman Fateh Ali <[EMAIL PROTECTED]> wrote:
>Dear friends..
>
>Any body tell me the real example other than msdn that
>how to use SEEK Method..
>
>Thanx...
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>
>
>'// =======================================================
>     Rules : http://ReliableAnswers.com/List/Rules.asp
>     Home  : http://groups.yahoo.com/group/vbHelp/
>     =======================================================
>     Post  : [EMAIL PROTECTED]
>     Join  : [EMAIL PROTECTED]
>     Leave : [EMAIL PROTECTED]
>'// =======================================================
>
>
>
>Yahoo! Groups SponsorADVERTISEMENT
>
>
>---------------------------------
>Yahoo! Groups Links
>
>    To visit your group on the web, go to:
>http://groups.yahoo.com/group/vbhelp/
>
>    To unsubscribe from this group, send an email to:
>[EMAIL PROTECTED]
>
>    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
>
>---------------------------------
>Do you Yahoo!?
>Friends.  Fun. Try the all-new Yahoo! Messenger
>
>[Non-text portions of this message have been removed]
>
>

_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. 
http://join.msn.com/?page=features/virus




------------------------ Yahoo! Groups Sponsor --------------------~--> 
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~-> 


'// =======================================================
    Rules : http://ReliableAnswers.com/List/Rules.asp
    Home  : http://groups.yahoo.com/group/vbHelp/
    =======================================================
    Post  : [EMAIL PROTECTED]
    Join  : [EMAIL PROTECTED]
    Leave : [EMAIL PROTECTED]
'// =======================================================
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
     http://groups.yahoo.com/group/vbhelp/

<*> To unsubscribe from this group, send an email to:
     [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
     http://docs.yahoo.com/info/terms/
 

Reply via email to