Re: Sql vraagje

Article View: be.comp.programming

Article #1132

Back to be.comp.programming Previous Next

#1132

From: Steven
Date: Thu, 27 Oct 2005 20:03

28 lines
1902 bytes

Ludo wrote:

> 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;
> 
> 
Ik denk niet dat dat correct is. Je bent immers niet zeker of het id met 
X - 1 bestaat. het id dat net voor 19 komt, is kleiner dan 19, maar je 
weet de exacte waarde niet. De id's zijn niet noodzakelijk opeenvolgend. 
Toch bedankt. Nog suggesties?

Groetjes,

Steven

Technical Details

Message-ID: <436132d2$0$10047$ba620e4c@news.skynet.be>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news2.google.com!newsread.com!news-xfer.newsread.com!news-out2.kabelfoon.nl!newsfeed.kabelfoon.nl!xindi.nntp.kabelfoon.nl!newsfeed.freenet.de!fr.ip.ndsoftware.net!proxad.net!proxad.net!skynet.be!newspost001!tjb!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> <Ap68f.33262$M%4.1566758@phobos.telenet-ops.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!news3.google.com!news2.google.com!newsread.com!news-xfer.newsread.com!news-out2.kabelfoon.nl!newsfeed.kabelfoon.nl!xindi.nntp.kabelfoon.nl!newsfeed.freenet.de!fr.ip.ndsoftware.net!proxad.net!proxad.net!skynet.be!newspost001!tjb!not-for-mail
Date: Thu, 27 Oct 2005 22:03:50 +0200
From: Steven <user@example.net>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.3) Gecko/20040910
X-Accept-Language: nl, en-us, 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> <Ap68f.33262$M%4.1566758@phobos.telenet-ops.be>
In-Reply-To: <Ap68f.33262$M%4.1566758@phobos.telenet-ops.be>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 28
Message-ID: <436132d2$0$10047$ba620e4c@news.skynet.be>
Organization: -= Belgacom Usenet Service =-
NNTP-Posting-Host: 9a9002d6.news.skynet.be
X-Trace: 1130443474 news.skynet.be 10047 81.241.11.176:10674
X-Complaints-To: usenet-abuse@skynet.be

Reply to Parent Message