Article View: borland.public.delphi.database.dotnet
Article #657Re: SQL with Like command ????
From: Wayne Niddery [TeamB]
Date: Tue, 05 Oct 2004 13:57
Date: Tue, 05 Oct 2004 13:57
14 lines
1479 bytes
1479 bytes
Hans wrote: > I'm trying following SQL string which doesn't work in Delphi > webapplication. > > SQLStr:='Select * From Relaties WHERE (Naam Like "Test")'; > SDA:=SQLDataAdapter.Create(SQLStr,Sqlcon); This is an SQL standard: field values need to be enclosed in *single* quotes, meta (field, table, etc) names must be enclosed in double quotes. -- Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com) RADBooks: http://www.logicfundamentals.com/RADBooks.html In a tornado, even turkeys can fly. - unknown
Technical Details
Message-ID:
<4162a857$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!nntp.abs.net!ash.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<41629951@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 1effe6,188547e999caab4e X-Google-Attributes: gid1effe6,public X-Google-Language: ENGLISH,ASCII-7-bit Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> Newsgroups: borland.public.delphi.database.dotnet References: <41629951@newsgroups.borland.com> Subject: Re: SQL with Like command ???? Date: Tue, 5 Oct 2004 09:57:43 -0400 Lines: 16 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 NNTP-Posting-Host: 69.17.156.109 Message-ID: <4162a857$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1096984663 69.17.156.109 (5 Oct 2004 06:57:43 -0700) X-Authenticated-User: wniddery Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.maxwell.syr.edu!nntp.abs.net!ash.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail