[Shravan K]

Alka,

       Based on what i’ve understood from your post i just want to give a suggestion it may not be what you want exactly. I feel i should try.

       The problem is to determine the for which first message(Parent) does the second message(Child) belongs.This is what i understood.

       If u look at both the messages u’ll find Patient Id is similar or you could say Patient Address or Patient visit information is similar.Based on these conditions you can figure out which child message belongs to appropriate Parent message.

      Similarly,i believe you can do it based on message control id too.

I’m not sure whether this will help you  😕 .i just hold my fingers cross.

-Shravan

[Shravan K]

Thanks keith,

                   Let me try this.

[Shravan K]

Can we be able to make connection to PLSQL using TclODBC ?

I’m new to tcl(i have enough knowledge),can any one suggest me how to get started.Our servers  are linux based.we are using PLSQL database.

[Shravan K]

Are you using any tcl proc in TPS Inbound data?

which format(option in list box) did u select from the Trix id determination Format list box ?

Can you come up in detail?

[Shravan K]

Michael,

           Its not much difficult to change it. Replace FT1.18 with PV1.18

that should work for him.

-Shravan

[Shravan K]

Ariba,

         I think you are wasting your time simply messing with proc and as per your previous messages you are not best with tcl.

         The simplest thing u need to do is write an if condition to kill the message.Its very simple

  Source                                                           Destination

1(0).0(0).FT1.00360.[0]                                  @Check_Chrg

#this statement will store the value present in the FT1.6  to  a variable.

1(0).0(0).FT1.00148.[0]                                   @Check_Pat_type

#this statement will store the value present in the FT1.18  to  a variable.

=NO CHRG                                                      @NoCharge

=LBC                                                              @Pat_type

#The above all are Copy statements

#Now take a if statement,in if

@Check_Chrg == @NoCharge  || @Check_Pat_type == @Pat_type

now Suppress the message

Hope this give you the solution.if you have already done 🙂  

-Shravan

[Author]

Replies