SQL查询是不是在VB6记录

Question

影响我有这样的SQL查询，它MSACCESS VBA运行良好，并创建一个MSACCESS查询，但在VB6它不影响：

SELECT 
    top 1000 NhapKHO.* 
    ,NHANVIEN.NAME as N 
    ,NHANVIEN.FNAME as FN 
    ,NhaCC.MaNCC 
    ,NhaCC.TenNCC 
    ,DMKHO.MaKho 
    ,DMKHO.TenKho 
FROM 
    DMKHO 
RIGHT JOIN (NhaCC RIGHT JOIN (NHANVIEN RIGHT JOIN NhapKHO ON NHANVIEN.ID = NhapKHO.ID_NV) ON NhaCC.ID = NhapKHO.ID_NCC) ON DMKHO.ID = NhapKHO.ID_KHO 
WHERE 
    ((MaNCC like '*ibo*') 
or 
    (TenNCC like '*ibo*') 
or 
    (NGUOIGIAO like '*ibo*') 
or 
    (fname like '*ibo*') 
or 
    (name like '*ibo*') 
or 
    (ngaynhap like '*ibo*') 
or 
    (nhapkho.ID like '*ibo*')) 
order by 
    NhapKHO.id desc 

结果返回空。

Answer 1

您的LIKE错误：使用％作为wildchar而不是*。要显示它：

... 
or 
    (name like '%ibo%') 
or 
...