Re: Kilka parametrów w jednym select

Article View: pl.comp.lang.delphi.bazy-danych

Article #70711

Back to pl.comp.lang.delphi.bazy-danych Previous Next

#70711

From: Morff
Date: Fri, 31 Aug 2007 21:20

14 lines
1206 bytes

> Może przejdzie coś takiego:
>
> ibQuery1.SQL.Add('SELECT * FROM LICZBA WHERE id in(:param1)');
> ibQuery1.ParamByName('param1').asString := '1,2,3,4';

nie przejdzie
bo  '1,2,3,4' to nie to samo co 1,2,3,4 ani '1','2','3','4'

-- 
Pozdrawiam
Morff
--------------------
AQQ : 141151 (morff@aqq.eu)

Technical Details

Message-ID: <op.txxz73ekq0kutt@xp_januszk.wag54gs>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.internetia.pl!newsfeed.tpinternet.pl!atlantis.news.tpi.pl!news.tpi.pl!not-for-mail

References: <46d82255$0$588$f69f905@mamut2.aster.pl> <fba0ib$1t6m$3@opal.icpnet.pl>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.internetia.pl!newsfeed.tpinternet.pl!atlantis.news.tpi.pl!news.tpi.pl!not-for-mail
From: Morff <morff1@wp.pl>
Newsgroups: pl.comp.lang.delphi.bazy-danych
Subject: Re: Kilka parametrów w jednym select
Date: Fri, 31 Aug 2007 23:20:17 +0200
Organization: tp.internet - http://www.tpi.pl/
Lines: 14
Message-ID: <op.txxz73ekq0kutt@xp_januszk.wag54gs>
References: <46d82255$0$588$f69f905@mamut2.aster.pl> <fba0ib$1t6m$3@opal.icpnet.pl>
NNTP-Posting-Host: cbp212.neoplus.adsl.tpnet.pl
Mime-Version: 1.0
X-Trace: atlantis.news.tpi.pl 1188595314 23001 83.30.113.212 (31 Aug 2007 21:21:54 GMT)
X-Complaints-To: usenet@tpi.pl
NNTP-Posting-Date: Fri, 31 Aug 2007 21:21:54 +0000 (UTC)
User-Agent: Opera Mail/9.23 (Win32)
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message