This is posted in the Data Access forum but it pertains to formula's as well and so I wanted to make sure it appears in searches here.
Hi everyone, I just loaded my first faq:
FAQ766-6779: How can I use a Multivalue or Date Range Parameter with a Command.
You guys have helped me figure out a lot and I wanted to give back something to the community.
I have seen this issue come up before and have run into myself. I finally figured out a workaround to it.
It is of course a last resort. You should always use CR's SQL generation whenever possible. A View would be my second choice. But in those cases of a very unfriendly dba, this method can help you get a command working with user friendly prompts that is all evaluated on the server.
I hope this helps some of you!
Joel Seguin
Hi everyone, I just loaded my first faq:
FAQ766-6779: How can I use a Multivalue or Date Range Parameter with a Command.
You guys have helped me figure out a lot and I wanted to give back something to the community.
I have seen this issue come up before and have run into myself. I finally figured out a workaround to it.
It is of course a last resort. You should always use CR's SQL generation whenever possible. A View would be my second choice. But in those cases of a very unfriendly dba, this method can help you get a command working with user friendly prompts that is all evaluated on the server.
I hope this helps some of you!
Joel Seguin