Passing multiple parameters in Toad cannot do so for Toad 8.5

[pectin232]

State is like this:

where p.person_id in GOAL_PERSON_ID)

it shows the pop up but I can pass only 1 value like say 542432 to it and if I put 542432,343212 ..... it will not run. Suggestions. I know for Toad 10 there is a settings for scanning Bound Statements in the SQL but in 8.5 there is no such feature.

 

[dgillz]

What the heck is a Toad doing in the crystal forum?

In crystal try this:

{p.person_id} in [12345, 23456, 34567]

This is in crystal as a record selection formula, not the database side.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html