Parameters can only be simple types, like string, integer etc. You can't
use a parameter query to do this. Instead, you will need to construct the
query at runtime thus:
qry.SQL.Text := ' select * from table where somefield in (';
for i = 0 to list.count - 1 do
if i = list.count - 1 then
qry.SQL.Text := qry.SQL.Text + list[i] + ')'
else
qry.SQL.Text := qry.SQL.Text + list[i] + ',';
qry.Open;
Andrew Masters <[EMAIL PROTECTED]> on 21/04/99 10:03:53
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
cc: (bcc: Peter Jones/Logistics&Information
Technology/Christchurch/Foodstuffs)
Subject: RE: [DUG]: Query Parameters
Sorry, I may not have explained myself clearly. I'm simply selecting from
one table (bad choice of names using ID). I'll try again...
SELECT * FROM TABLE
WHERE SOMEFIELD IN (:SomeValueList)
I realise IN is not the most efficient but it makes constructing the SQL at
runtime very handy in this case.
-----Original Message-----
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 21, 1999 8:45 AM
To: Multiple recipients of list delphi
Subject: Re: [DUG]: Query Parameters
It's not possible. You will have to use multiple OR's or a join. Joins
are generally quicker than IN anyway.
Andrew Masters <[EMAIL PROTECTED]> on 20/04/99 18:56:42
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
cc: (bcc: Peter Jones/Logistics&Information
Technology/Christchurch/Foodstuffs)
Subject: [DUG]: Query Parameters
Hi All,
I have a query (simplified here) like
SELECT * FROM TABLE
WHERE ID IN (:IDList)
Under WISQL something like
SELECT * FROM TABLE
WHERE ID IN (2,3)
works just fine. In my code if I set the param :IDList to say '2,3' it does
not work (returns nothing but no exception either). When set to say '2' or
'3' it works just fine. The IDList parameter is a string type. Is there a
rule of parameter substitution I'm breaking here ?
Thanks
Andrew Masters
Clinical Solutions Ltd
Auckland, NZ
Ph: +64-9-476-0106
Fax: +64-9-476-0108
e: [EMAIL PROTECTED]
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
(UUEncoded file named: att1.unk follows)
(Its format is: File type unknown )
begin 644 att1.unk
M>)\^(@$5`0:0"``$```````!``$``0>0!@`(````Y`0```````#H``$(@`<`
M&````$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0V`!``"`````@`"``$$
MD`8`J`$```$````0`````P``,`(````+``\.``````(!_P\!````1P``````
M``"!*Q^DOJ,0&9UN`-T!#U0"`````&1E;'!H:4!D96QP:&DN;W)G+FYZ`%--
M5%``9&5L<&AI0&1E;'!H:2YO<F<N;GH``!X``C`!````!0```%--5%``````
M'@`#,`$````5````9&5L<&AI0&1E;'!H:2YO<F<N;GH``````P`5#`$````#
M`/X/!@```!X``3`!````%P```"=D96QP:&E`9&5L<&AI+F]R9RYN>B<```(!
M"S`!````&@```%--5%`Z1$5,4$A)0$1%3%!(22Y/4D<N3EH````#```Y````
M``L`0#H!````'@#V7P$````5````9&5L<&AI0&1E;'!H:2YO<F<N;GH`````
M`@'W7P$```!'`````````($K'Z2^HQ`9G6X`W0$/5`(`````9&5L<&AI0&1E
M;'!H:2YO<F<N;GH`4TU44`!D96QP:&E`9&5L<&AI+F]R9RYN>@```P#]7P$`
M```#`/]?``````(!]@\!````!`````````(!6`$$@`$`'````%)%.B!;1%5'
M73H@475E<GD@4&%R86UE=&5R<P`M"0$%@`,`#@```,\'!``5``D``P`U``,`
M,P$!((`#``X```#/!P0`%0`(`#@`#0`#`#\!`0F``0`A````14%#-3=$,T1#
M,$8W1#(Q,4%&,S4T-#0U-3,U-#`P,#``"0<!`Y`&`,`(```A````"P`"``$`
M```+`",```````,`)@``````"P`I```````#`"X```````,`-@``````0``Y
M`,!NTDMQB[X!'@!P``$````<````4D4Z(%M$54==.B!1=65R>2!087)A;65T
M97)S``(!<0`!````%@````&^BW%+L#U]Q>OWP!'2KS5$15-4`````!X`'@P!
M````!0```%--5%``````'@`?#`$````5````86UA<W1E<G-`8W-L=&0N8V\N
M;GH``````P`&$%`NC;(#``<0VP4``!X`"!`!````90```%-/4E)9+$E-05E.
M3U1(059%15A03$%)3D5$35E314Q&0TQ%05),64E-4TE-4$Q94T5,14-424Y'
M1E)/34].151!0DQ%*$)!1$-(3TE#14]&3D%-15-54TE.1TE$*4E,3%1264$`
M`````@$)$`$```"=!0``F04``#4*``!,6D9U92N"XW<`"@$#`?<@`J0#XP(`
M8X)H"L!S970P(`<3AP*#`%`.]G!R<3(/]B9]"H`(R"`["6\R-68U`H`*@75C
M`%`+`V,#`$$+8&YG,3`S,P<+I@8`!;!R>2P@2<(@`,!Y(&YO!4`/@.!V92!E
M>`M3"8`6X`)Y#[!L9B!C;&41"L!L>2X6P"=M(+T`D&T+4!<0&($%D'0+@/1G
M(`-2(`(@%Z`!D1C@,"`H8F$80`]P;VE*8Q>@;QBP;F$'@G6C`)`:@4E$*1E"
M;`,@HG06D"!A9PMQ+AZ`!PJB"H0*@%-%3$5#`%0@*B!&4D]-,"!404(?D!ZT
M5T@815)%!@`@($5&2=4?@$06P$X;D#H68`>`EE8'0`I03`0`="D>NO\6T`EP
M!T`$`!>@(@$$`!<C_'1H%Z`$8",`%[`!(!P@HPB0`C`@8G4%0&D%0/T`P&L'
MD06@`(`=\!2`&F/Q)3)344P>(`5`)X`",)T'<2`7D!X!#X!N9!<0YPN`)2$D
MP6-A#[`>JQZX\PLP)$`S-@%`%1`!0!%`AQ=`&D$0A#$V("TMTGI/!1!G"X`'
M0`70!Y!S_1XP92W3'K8LY"RQ"Q,LYF!I+3$T-`%`)$`QW#@P`4`,T#%S8A_P
M`V%*.@R#8@_@<&H;`7,N0`(0!'`C`'4!(',M!0"0+@6@+FYZ(%M@4TU44#HS
MGS2G7=\>M3*@!F`",#,'5PF`-=$V9!<`%K!!$4`#$3(Q"1:P,3DZ$"`X.C1*
M-0_P33=75&\S!TU\=6P:8`M0%Z`)<"8`<#\F$@0@'&$D005``0!L<&,J(#=8
M=6)J&D$S!U*$93HU,$151UT_T/91"E`>`5`*P!RA+0`/H`\O?S"*+#054C4Q
M,CFC"Z<JSTET)R34<"6`IP"0&V$90"!9"&`@`_!S'<$7<W1O'.$E43P63^92
M1=$%L6$@-;`>84;0_DI)@4%5"L`7H"\`&"!`X/,=P!<0<74<(";P!<`E,.<#
MD2(!`'!Y=Q<`*J]-C]T>YT$IH`EP!^!-*G!!(HP@/!R@4`1`8W,\(!ID--0^
M&O$YL#`O,(PT+SHA,>`Z-38Z8+HR'KI0&.$D80EP<T9`5RF@1\(]Q$`]Q"X%
ML&>_-0$>NCM11M`[_ST/:5!@YU4/49(>M&-C5R(;D5M2CE!!$DG1-=$O3&\N
M4$,C`!P@<R9);@(0<K\`P!I@`B`>M%N"1M!4!9`&:!<P"0!G>2]#:)\%$",`
M#W`(<`]P+T8V)W\C)3ZV1M`_]4!?3F]D6TCU67!!'<`L(SP7<TE02W#]*4(H
M&:,&D`B0&$`E0`EP_BD]82;P'K\?SR#7'5`A])L=4"+O52F@2\%722A"_G,B
M82H1&H%HSVG?:N\B$:@R+#,C*W<%L&L$(/YJ'/`%0"7@&"`900.@&&#_)R$!
M`"2P&+`6T`^Q)2,*L;T<H"!L)4?"+N`7$"=R(?(G)I)D;P>0;P07,G,B_QN0
M"7`T4`2@)--N<R9B%S#_%[$<,`4P7@$7L":@:&$=<?Y7)4`#H'4S=J9W0`6P
M;P3V)W<T<R]4)4%V)76S7#//),%)4"=A)\-Y<'0"!"!_>P)G`6\$)X`;<1QA
M?VAS7S[`72$T4'J3&6)B)!%K^QIR@6,_5DLI@7-03R]!-_Y#)$`#`"I@`R`6
M8`I`7?)=!"!,44"&912`:Q519"D6L$Y:4X5H/]`K-@`T+3DM-#<V+8HP%9`V
M;P1&87B+#?XX;P0_P5"/5AUO!"W3D,^_D=^2[Y/_+U9;@@?"6B0AZ2F1($19
M-%4/L%!!"<#]"&!P+<"6AG9#E\!9KU87_UZ4FGHXL(-@)J`_P14#5W"#%V`"
M0'`Z+R]WG0#^+ID\+))7<$2/GS^/_Z&O_Z*_H\^4/Y5/EE^7;YA_F8^_FI^;
MKYR_G<]O1A(!`+!``````P`0$``````#`!$0``````,`@!#_____0``',*!?
MG#EPB[X!0``(,*!?G#EPB[X!"P``@`@@!@``````P````````$8``````X4`
M```````#``*`""`&``````#`````````1@`````0A0````````,`!8`((`8`
M`````,````````!&`````%*%``"W#0``'@`E@`@@!@``````P````````$8`
M````5(4```$````$````."XP``,`)H`((`8``````,````````!&``````&%
M````````"P`O@`@@!@``````P````````$8`````#H4````````#`#"`""`&
M``````#`````````1@`````1A0````````,`,H`((`8``````,````````!&
M`````!B%````````'@!!@`@@!@``````P````````$8`````-H4```$````!
M`````````!X`0H`((`8``````,````````!&`````#>%```!`````0``````
M```>`$.`""`&``````#`````````1@`````XA0```0````$`````````'@`]
;``$````%````4D4Z(``````#``TT_3<``$%$
`
end
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
