ADOQuery SQL Problems with Like syntax

Article View: borland.public.cppbuilder.database.ado

Article #3787

Back to borland.public.cppbuilder.database.ado Previous Next

#3787

From: Joachim
Date: Sat, 22 Jun 2002 12:36

12 lines
1412 bytes

Hi,
first I have to say that I am new to ADO. I tried to make a sql-query "
select * from table where 'column1' like 'te%' " but that did not work. I
got no records. It should get the record where column1 is "test". The
Provider I use is Microsoft Jet 4.0 SP3.
When i make " like '%' "  it works and I get all records.
I want to develope a DatabaseApplication with Microsoft Access Databases.
Perhaps Microsoft Jet is not the best way, I don�t know. Perhaps somebody
could inform me about better ways to work with Microsoft Access DB.

Thanks,
Joachim

Technical Details

Message-ID: <3d146e90_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!logbridge.uoregon.edu!netnews.com!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,70da1ab8b9bcf5f6,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-06-22 05:38:51 PST
From: "Joachim" <mfgjojo@gmx.de>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ADOQuery SQL Problems with Like syntax
Date: Sat, 22 Jun 2002 14:36:30 +0200
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: 217.229.150.169
Message-ID: <3d146e90_2@dnews>
X-Trace: dnews 1024749200 217.229.150.169 (22 Jun 2002 05:33:20 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!logbridge.uoregon.edu!netnews.com!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews