🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: be.comp.programming
Article #1131

Re: Sql vraagje

#1131
From: Ludo
Date: Thu, 27 Oct 2005 15:31
26 lines
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-mail
References: <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