Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Test of existence on a Table \"Oracle\" › Test of existence on a Table \"Oracle\"
So,
the problem is not when I receive, but in my Expression form, when I do:
StatusRoom = Message_ResponseSelect.parameters.Operation1.PATIENT_OMNIS.Select.Record.PATIENT_ROOM;
StatusRoom is a variable that I’ve created!
the problem is that if the patient doesn’t exist, the ReceiveMessage is NULL!!!
So I don’t know how to do the test!! 😕
I would like to do a test like this:
\”if the receive message doesn’t exist, then StatusRoom = -1, else StatusRoom = Message_ResponseSelect.parameters.Operation1.PATIENT_OMNIS.Select.Record.PATIENT_ROOM; \”
Maybe should I do with XPath ??? Or with .Net Component ?? but how ?? 🙁
Help me please !! 🙁
Thank you in advance
A.C.