| Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free! |
VB6 Access Wildcards
|
Original Message
|
Name: Global
Date: October 27, 2003 at 01:08:09 Pacific
Subject: VB6 Access Wildcards
OS: 2000
CPU/Ram: 1800
|
Comment: I am trying to use the following statement .Source = "Select * from NewData WHERE PlData LIKE '100*'" This would return all ID's starting with 100, however I keep getting no returned results. I can run a query in Access to do exactly the same thing and I do indeed get the results that I want/expect. I have read various articles regarding the LIKE statement combined with wildcards and there is a known problem that produce Null results. My problem is that I cannot work out the solution, I am using ActiveX Data Objects 2.5 which according to Microsoft solves the known bug, but it doesn't in my case!! Help? Regards,
Global
Report Offensive Message For Removal
|
Post Locked
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
Go to Programming Forum Home
