Re: How do I Pass parameters to a QueryDataset?

Article View: borland.public.jbuilder.java.language

Article #7976

Back to borland.public.jbuilder.java.language Previous Next

#7976

From: Michael Rachow
Date: Fri, 04 May 2001 14:18

27 lines
1870 bytes

Column colSearch = new colSearch;
colSearch.setColumnName("ForSearching");
colSearch.setDataType(com.borland.dx.dataset.Variant.INT);
colSearch.setSqlType(4);
parameterRow1.setColumns(new Column[] {colSearch});
parameterRow1.setInt("ForSeaching", 7);

colSearch.setInteger("ForSeaching");

// part of your setQuery statement:
 ......where TABLE_A.COL_1 = ?, parameterRow1, .....      // This is
position dependent
// or
 ......where TABLE_A.COL_1 = :ForSearching, parameterRow1, .....      //
This is not

"Srinivas Lanka" <srinivas_lanka@horizon-bcbsnj.com> schrieb im Newsbeitrag
news:3af1b8fa$1_1@dnews...
>
> Hello!
>   How do I pass parameters to a QueryDataSet?
> I have the SQL query as
>    select * from TABLE_A where TABLE_A.COL_1 = ?
> Can someone please let me know the steps to achieve this.
>
> Thanks
>

Technical Details

Message-ID: <3af2bda5_1@dnews>

Path:

arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!cyclone-sf.pbi.net!63.208.208.143!feed2.onemain.com!feed1.onemain.com!newsfeed1.bredband.com!bredband!diablo.netcom.net.uk!netcom.net.uk!fr.clara.net!heighliner.fr.clara.net!fr.usenet-edu.net!usenet-edu.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

References: <3af1b8fa$1_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f74b3,d5c8a96c32a2ba45
X-Google-Attributes: gidf74b3,public
X-Google-ArrivalTime: 2001-05-04 07:42:03 PST
From: "Michael Rachow" <mrachow@BeraCom.de>
Newsgroups: borland.public.jbuilder.java.language
References: <3af1b8fa$1_1@dnews>
Subject: Re: How do I Pass parameters to a QueryDataset?
Date: Fri, 4 May 2001 16:18:11 +0200
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 217.80.15.136
Message-ID: <3af2bda5_1@dnews>
X-Trace: dnews 988986789 217.80.15.136 (4 May 2001 07:33:09 -0700)
Path: arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!cyclone-sf.pbi.net!63.208.208.143!feed2.onemain.com!feed1.onemain.com!newsfeed1.bredband.com!bredband!diablo.netcom.net.uk!netcom.net.uk!fr.clara.net!heighliner.fr.clara.net!fr.usenet-edu.net!usenet-edu.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Reply to Parent Message