Article View: be.comp.programming
Article #1131Re: Sql vraagje
From: Ludo
Date: Thu, 27 Oct 2005 15:31
Date: Thu, 27 Oct 2005 15:31
26 lines
1765 bytes
1765 bytes
> Beste,
>
> Ik denk niet dat je het probleem begrijpt. En mocht je het toch begrepen
> hebben, dan begrijp alleszins jouw oplossing niet. Toch bedankt.
>
> Groetjes,
>
> Steven
Var A,B,X := Integer;
Query1: TQuery;
begin
Query1 := TQuery.Create(Self);
Query1.SqlConnection := SqlConnection1;
X := 19;
A := X - 1;
B = X + 1;
With Query1 do
begin
Sql.Clear;
Sql.Add('Select * From Jouw_Tabel Where Id Between A and B' Order
By Id');
Open;
end;
Technical Details
Message-ID:
<Ap68f.33262$M%4.1566758@phobos.telenet-ops.be>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!newsreader.com!feed7.newsreader.com!newsreader.com!nntp.telenet.be!kwabbernoot.telenet-ops.be!phobos.telenet-ops.be.POSTED!not-for-mailReferences:
<4360e3b2$0$322$ba620e4c@news.skynet.be> <jw58f.33230$Y45.1572890@phobos.telenet-ops.be> <4360ef18$0$29028$ba620e4c@news.skynet.be>Show Full Headers
Complete Article Headers
X-Google-Thread: fcea4,cbd8331c80a6215d X-Google-Attributes: gidfcea4,public X-Google-Language: DUTCH,ASCII-7-bit Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!newsreader.com!feed7.newsreader.com!newsreader.com!nntp.telenet.be!kwabbernoot.telenet-ops.be!phobos.telenet-ops.be.POSTED!not-for-mail From: Ludo <jvbsoft.verwijder@telenet.be> User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: nl-NL, nl, en MIME-Version: 1.0 Newsgroups: be.comp.programming Subject: Re: Sql vraagje References: <4360e3b2$0$322$ba620e4c@news.skynet.be> <jw58f.33230$Y45.1572890@phobos.telenet-ops.be> <4360ef18$0$29028$ba620e4c@news.skynet.be> In-Reply-To: <4360ef18$0$29028$ba620e4c@news.skynet.be> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Lines: 28 Message-ID: <Ap68f.33262$M%4.1566758@phobos.telenet-ops.be> Date: Thu, 27 Oct 2005 15:31:44 GMT NNTP-Posting-Host: 213.119.103.57 X-Complaints-To: abuse@telenet.be X-Trace: phobos.telenet-ops.be 1130427104 213.119.103.57 (Thu, 27 Oct 2005 17:31:44 MEST) NNTP-Posting-Date: Thu, 27 Oct 2005 17:31:44 MEST Organization: Telenet Internet