Test of existence on a Table \"Oracle\"

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Test of existence on a Table \"Oracle\" › Test of existence on a Table \"Oracle\"

November 28, 2005 at 8:27 AM #12426
community-content

    Hi,

    the problem is when I receive, because I can send a request \”Select\”, for instance, I do a select * where IDPatient = IDPatientSource

    Then, when I receive the message, if the patient exists, i do an update, and there are maybe 5 different updates, which depend on the value of the variable \”StatusPatient\”, contained in the response message. If the patient doesn’t exists, I simply do an insert !

    I would like to do a .netComponent, but I’m not able to do it!
    But I’m sure that it’s the best solution!

    So the big problem of my orchestration is that I don’t know how to do when my response message is null !!!

    Thank you
    A.C.