Re: Query probleempje in Delphi ...

Article View: be.comp.programming

Article #2774

Back to be.comp.programming Previous Next

#2774

From: Sam
Date: Tue, 16 Mar 2004 12:59

24 lines
1735 bytes

"jvb" <jvbsoft.verwijder.dit@pandora.be> wrote in message
news:Sjo5c.36238$YQ4.2454574@phobos.telenet-ops.be...
> > Bij mij werkt het op volgende manier:
> >
> > 'Select Naam From Klanten Where Naam = ' + '''' + 'JANSEN' + '''' ;
>
>
> Hmm bij mij niet, maar ik ben wat gaan experimenteren, met onderstaande
code
> lukt dit prima :
>
> With SqlQuery1 do
>  begin
>      DataSet.Commandtext := 'Select Naam From Klanten Where Naam =
> ''+''''FieldByName(Klantnaam).AsString+'''';
>      Open;
>  end;
>
> Dank ...
>
Zoals ik al zei, een ' meer zetten...

Sam.

Technical Details

Message-ID: <c36tnf$fa$1@snic.vub.ac.be>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!newsfeed.vmunix.org!aotearoa.belnet.be!ikaria.belnet.be!news.belnet.be!snic.vub.ac.be!not-for-mail

References:

<GCh5c.35519$0Q2.2359403@phobos.telenet-ops.be> <dpn5c.2764$gW.238726240@hestia.telenet-ops.be> <Sjo5c.36238$YQ4.2454574@phobos.telenet-ops.be>

Show Full Headers

Complete Article Headers

X-Google-Language: DUTCH,ASCII-7-bit
X-Google-Thread: fcea4,ede0e894c4ff961b
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2004-03-16 05:00:03 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!newsfeed.vmunix.org!aotearoa.belnet.be!ikaria.belnet.be!news.belnet.be!snic.vub.ac.be!not-for-mail
From: "Sam" <sam.en.son@pi.be>
Newsgroups: be.comp.programming
Subject: Re: Query probleempje in Delphi ...
Date: Tue, 16 Mar 2004 13:59:22 +0100
Organization: VUB/ULB Computing Centre
Lines: 26
Message-ID: <c36tnf$fa$1@snic.vub.ac.be>
References: <GCh5c.35519$0Q2.2359403@phobos.telenet-ops.be> <dpn5c.2764$gW.238726240@hestia.telenet-ops.be> <Sjo5c.36238$YQ4.2454574@phobos.telenet-ops.be>
NNTP-Posting-Host: 144.248.16.19
X-Trace: snic.vub.ac.be 1079441967 490 144.248.16.19 (16 Mar 2004 12:59:27 GMT)
X-Complaints-To: usenet@snic.vub.ac.be
NNTP-Posting-Date: 16 Mar 2004 12:59:27 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Forwarded: by - (DeleGate/5.8.7)
X-Forwarded: by - (DeleGate/5.8.7)

Reply to Parent Message