- This topic has 5 replies, 5 voices, and was last updated 5 years, 7 months ago by .
-
Topic
-
I am now for the first time needing to query an outside SQL DB in real-time, and curious where/how to start. I would like to do within tcl if at all possible. The need is to query an EPI system where it stores (2) enterprise IDs [ID1 ID2 for simplicity here] along with various facilites’ med rec numbers.
Example: the receiving system generates its’ own ID, here ID2. When the sender sends out data, ID1 is always known. I need to check to see if ID2 exists based on ID1 similar to:
USE EPI
SELECT ID2 WHERE ID1 = ‘12345’
IF query returns null, we send PID-4 as null, and the receiving system generates the ID value. If the query returns the ID2 value, I plug that in to PID-4, and recieving systems gets what it needs and *doesn’t* produce a duplicate chart.
Any help would be appreciated. Thanks, -robbie, ARHS IT
- The forum ‘Cloverleaf’ is closed to new topics and replies.