Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    6

    Unanswered: Access with VB6 Stored Procedure and Wildcards

    I have Access 2000 and VB6 using ADO to call stored procedures. All the procedures work with the exception of a particular stored procedure:

    PARAMETERS [pbar_PK] Text ( 255 );
    DELETE *
    FROM tblFoo
    WHERE bar_PK Like [pbar_PK];

    PROBLEM:
    When I run the stored procedure with 5.* in Access it finds the appropriate records and deletes them. When I call it from VB6 using 5.* it deletes no records.

    I'm passing it in as a Variant/String. Other delete sps work. It seems to be a problem with the wildcard. All watches and locals show the parameter to be 5.*

    Thanks for any suggestions.

    -rufford

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Try to use the % sign instead of the *

  3. #3
    Join Date
    Sep 2004
    Posts
    6
    % is used as the wildcard for SQL 7
    * is used as the wildcard for MS Access

    Thanks

    -rufford

Posting Permissions

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