SQL with Like command ????

Article View: borland.public.delphi.database.dotnet

Article #655

Back to borland.public.delphi.database.dotnet Previous Next

#655

From: Hans
Date: Tue, 05 Oct 2004 12:52

10 lines
1108 bytes

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);

I get the error that Delphi sees Test as Colum?????

How to handle these SQL strings in Delphi?

Hans

Technical Details

Message-ID: <41629951@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!proxad.net!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1effe6,188547e999caab4e,start
X-Google-Attributes: gid1effe6,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Hans" <info@tct.nl>
Newsgroups: borland.public.delphi.database.dotnet
Subject: SQL with Like command ????
Date: Tue, 5 Oct 2004 14:52:56 +0200
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: 213.10.69.25
Message-ID: <41629951@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1096980817 213.10.69.25 (5 Oct 2004 05:53:37 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!proxad.net!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail