>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.
I'm afraid that the parameter binding method needs to associate a single
value type to each parameter so you cannot supply a list which is multi-value
as a parameter. Essenially the purpose of parameters is to let the database
perform some optimisation by binding somme fields in a selection as fixed and
some as variable - the fixed fields will have values supply by you and it will
search for the rest, currently the binding process does not support lists - I haven't
looked into Oracle8s' SQL extensions though.
--
Aaron Scott-Boddendijk
Jump Productions
(07) 838-3371 Voice
(07) 838-3372 Fax
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
