var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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 );
WHERE bar_PK Like [pbar_PK];
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.
Try to use the % sign instead of the *
% is used as the wildcard for SQL 7
* is used as the wildcard for MS Access