Results 1 to 4 of 4

Thread: check if exists... *Resolved*

Threaded View

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Jan 2003
    Posts
    23

    check if exists... *Resolved*

    VB Code:
    1. Dim myConnection As ADODB.Connection    
    2. Dim Manu As ADODB.Recordset            
    3.  
    4. myConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbloc
    5. myConnection.Open
    6.  
    7. Set Manu = myConnection.Execute("SELECT * FROM installatie WHERE PC_ID LIKE text")
    8.  
    9. Myconnection.close
    10. manu.close

    The above code works fine, but i wan't a query that checks if a record excists... how do i do that?

    Thx
    Last edited by BroesWillems; May 15th, 2003 at 05:53 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width