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
