Getting database value into a rule policy
- From: "solid" <solid@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 29 Aug 2005 14:25:19 -0700
For the sake of learning Biztalk, I'm running through a number of test
scenarios.
My working orchestration retrieves an infopath form from a sharepoint form
library and changes a value in the form and then puts the form back in the
sharepoint form library. No problems here.
What I would like to get working is for the value that is changed to come
from a database table. In my testing I have a table with a field called
"age" and the value in row 1 is 111. I want to get that value in a rules
policy and set the xml field (also called age) to 111.
Long story short, I added a database fact in the vocabulary to get the value
from the database, but my policy only works in testing. When the
orchestration calls the policy nothing is changed.
One thing I've noticed is that when I test the policy I have to add a
database instance as well as the xml instance. Is there something else I
need to add when calling the policy from the orchestration besides just
sending the message?
solid
.
- Follow-Ups:
- Re: Getting database value into a rule policy
- From: Leo Gan
- Re: Getting database value into a rule policy
- Prev by Date: Send Port subscribing to another sendport
- Next by Date: Re: Filter Expression
- Previous by thread: Send Port subscribing to another sendport
- Next by thread: Re: Getting database value into a rule policy
- Index(es):
Relevant Pages
|
Loading