🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: be.comp.programming
Article #2769

Re: Query probleempje in Delphi ...

#2769
From: jvb
Date: Mon, 15 Mar 2004 19:44
14 lines
1592 bytes
> Bij mij werkt het op volgende manier:
>
> 'Select Naam From Klanten Where Naam = ' + '''' + 'JANSEN' + '''' ;

Dit is een interessante tip, hoe vul je dat in in onderstaande code ??


With SqlQuery1 do
 begin
     DataSet.Commandtext := 'Select Naam From Klanten Where Naam =
'''+Klanten.FieldByName('Naam').AsString+'''';
     Open;
 end;
Technical Details
Message-ID: <kIn5c.36156$zP2.2332788@phobos.telenet-ops.be>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-09!supernews.com!newsfeed.gamma.ru!Gamma.RU!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!t-online.de!newsfeed.wirehub.nl!newsgate.cistron.nl!aotearoa.belnet.be!news.belnet.be!ossa.telenet-ops.be!phobos.telenet-ops.be.POSTED!not-for-mail
References: <GCh5c.35519$0Q2.2359403@phobos.telenet-ops.be> <dpn5c.2764$gW.238726240@hestia.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-15 11:44:17 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-09!supernews.com!newsfeed.gamma.ru!Gamma.RU!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!t-online.de!newsfeed.wirehub.nl!newsgate.cistron.nl!aotearoa.belnet.be!news.belnet.be!ossa.telenet-ops.be!phobos.telenet-ops.be.POSTED!not-for-mail
From: "jvb" <jvbsoft.verwijder.dit@pandora.be>
Newsgroups: be.comp.programming
References: <GCh5c.35519$0Q2.2359403@phobos.telenet-ops.be> <dpn5c.2764$gW.238726240@hestia.telenet-ops.be>
Subject: Re: Query probleempje in Delphi ...
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <kIn5c.36156$zP2.2332788@phobos.telenet-ops.be>
Date: Mon, 15 Mar 2004 19:44:16 GMT
NNTP-Posting-Host: 81.165.156.41
X-Complaints-To: abuse@telenet.be
X-Trace: phobos.telenet-ops.be 1079379856 81.165.156.41 (Mon, 15 Mar 2004 20:44:16 MET)
NNTP-Posting-Date: Mon, 15 Mar 2004 20:44:16 MET
Organization: Telenet Internet