VB6.0 URGENT


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: VB6.0 URGENT

  1. #1
    didem Guest

    VB6.0 URGENT



    I COULDN'T FIND THE SOLUTION HOW TO SEARCH TWO ALFABETICAL
    CHARECTERS.

    price1.Recordset.FindFirst "CUSTID='" & (Label19) & "And style='" & Text3
    & "'"



    PLEASE HELP




  2. #2
    Brent Guest

    Re: VB6.0 URGENT


    In short you can't... the Findfirst Method only support searching on one
    column, therefore you would have to search for CUSTID and then search on
    STYLE.

    price1.Recordset.Find "CUSTID LIKE '" & Label19.Caption & "'", _
    1, adSearchForward, price1.Recordset.Bookmark

    If Not price1.Recordset.EOF Then
    ' We found the CUSTID, now search from this location for the
    ' Style in Text3
    price1.Recordset.Find "STYLE LIKE '" & Text3.Text & "'", 1, _
    adSearchForward, price1.Recordset.Bookmark
    If Not price1.Recordset.EOF Then
    ' Found both the CUSTID and STYLE
    Else
    ' Did not find the STYLE
    End If
    Else
    ' We did not find a CUSTID
    End If

    "didem" <didemsa@usa.net> wrote:
    >
    >
    >I COULDN'T FIND THE SOLUTION HOW TO SEARCH TWO ALFABETICAL
    >CHARECTERS.
    >
    >price1.Recordset.FindFirst "CUSTID='" & (Label19) & "And style='" & Text3
    >& "'"
    >
    >
    >
    >PLEASE HELP
    >
    >
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center