Multi-value parameters for commands and stored procedures

Thursday 15 May 2008 @ 9:43 am

Last year I published the “Expert’s Guide to SQL Expressions, Options and Commands“, just as CR 12 was coming out. In the Guide I explained the workaround for passing multi-value parameters to SQL Commands. Up until today I had missed a new (but little noticed) feature of CR 12. Commands parameters in CR 12 have a new option that allows multi-value parameters. No workaround needed. And, because you can launch stored procedures from a command object, you can now pass true multi-value parameters directly to your stored procedures.

You will see this feature at the bottom of the window when you add a new parameter to a Command. However, if you are using versions 9 – 11 you will not have this feature.

Leave a Reply

Recrystallize Pro

Crystal Reports Server