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\"

#12427

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.