Using "like" in a C # program to query an Access database query for empty issues

Source: Internet
Author: User
Tags oracle database

Today, a particularly strange question was discovered during the development process: in Access, when like queries are executed in an Access database, Discovery can query the results, which are performed on the database, select * from kpproj where kpname like ' * Test * ', but the same statement is empty in the C # program, what's the situation?

The problem is really tangled, with previous development experience, like in access to use the * number, but SQL Server Oracle database in the standard%, why not at this time. After searching for information, the last thing we found was a connection to the access driver, which used to be an MDB, a database that was accdb, and then a Win7 64-bit development system, so I can't use "*" here because I have access to the OLE DB driver in my program.       If you are using DAO to access the Access database, you must use "*". discovery is not encountered access on the use of *, so to be based on the actual driver to determine;

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.