Re: Getting database value into a rule policy

Ok, that makes sense. The only parameter that I can send to the call rules
is the multi-part message type. I don't see where I can send a database
connection instance (meaning it doesnt appear in the drop down parameter
list).

Thank you for your help.

David

"Leo Gan" wrote:

> Yes,
> You have to set up the Parameters of Rule shape (they are like "instances"
> of the fact objects)
>
> --
> Leonid Ganeline,
> BizTalk Developer
> http://public.fotki.com/leogan/
>
> "solid" <solid@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:EF566FFC-C0B5-48D8-A911-D8B078EE6C89@xxxxxxxxxxxxxxxx
> > 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
>
>
>
.

Relevant Pages

  • Re: Getting database value into a rule policy
    ... You need to have a variable of type Dataconnection ... instances in the composer or orchestration. ... I don't see where I can send a database ... but my policy only works in testing. ...
    (microsoft.public.biztalk.general)
  • Getting database value into a rule policy
    ... My working orchestration retrieves an infopath form from a sharepoint form ... I added a database fact in the vocabulary to get the value ... but my policy only works in testing. ...
    (microsoft.public.biztalk.general)
  • Re: Transactional Adapter and Orchestration
    ... loss of the database connection during orchestration processing is my ... Since I have no way to revert the database field value ... back to the original value because I've lost the database connection, ... Microsoft Online Community Support ...
    (microsoft.public.biztalk.general)
  • Re: confusing relationships
    ... Even if some of the people in your database will never be policyholders, ... Do some of these named spouses also have multiple spouses whom you need ... Is exactly one insured person named on each policy? ... ..i have another table which has all policy types (time periods ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Database Corruption after Exchange SP 2
    ... I repaired my Exchange database successfully and I can perform backups ... A conflict in Group Policy can cause these events to occur. ... Windows XP to configure domain policies, you may find that the policies do ...
    (microsoft.public.windows.server.sbs)