Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

infinite IF loop

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

4 Users

0 Reactions

69 Views

RSS

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

Topic starter

I have inadvertantly created an inifinite / unending IF statement. woops. Or at least I think that's the problem. It does not occur when one indifidual form is loaded but when a certain combination of forms is loaded.

Does anyone know of a way to get rid of this document? Every time I try to join the update, EMR basically stops responding and I have to close it in task manager. I can't sign it or discard it. It's just sitting on my desktop. Any help would be greatly appreciated!!!

Posted : August 19, 2015 1:30 pm

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Download Centricity Administration Toolbox. You will need help from your IT support to supply the necessary information: database host IP, database name, database admin user, database admin password. You also need the Doc ID. Good luck.

Posted : August 19, 2015 1:54 pm

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

Topic starter

Thanks!

Posted : August 20, 2015 4:54 am

rgavrilles

(@rgavrilles)

Posts: 17

Eminent Member

You may also be able to just contact GE for a quick fix. In the past when I've encountered this, they've hopped on the phone and just used the SQL Command Line to change the status of the document from "On Hold" to "Unsigned" which allows you to use the EMR "Actions->Documents->Remove" option to clear the document, rather than trying to open and encountering the buggy code.

Posted : August 20, 2015 5:32 am

ken.takenaka

(@ken-takenaka)

Posts: 212

Reputable Member

Topic starter

ok great idea. That would be ideal

Posted : August 20, 2015 5:44 am

ErnieT

(@erniet)

Posts: 479

Honorable Member

I have a sql script that you can use to remove the forms from an update. It is a multi step process but it will remove the forms from the note and it will allow you to then open the note and either load new forms or discard or file it in error.

Here it is.

-- Step 1: Find the SDID, PID, and chart by date using patientid from patients chart
select d.sdid, pp.pid, db_create_date,d.NOTETEXT
from patientprofile as pp join document as d on (pp.pid = d.pid)
where pp.patientid ='194012' and not(d.NOTETEXT = '' or d.NOTETEXT is null)

-- Step 2: To see NOTETEXT, enter SDID and PID from Step 1 for correct date to verify correct chart document
select db_create_date, notetext, * from document where pid = xxxxxx and sdid = xxxxx

-- Step 3: To clear NOTETEXT, enter SDID and PID from Step 2, execute begin tran, execute update document set before executing commit
begin tran
update document set notetext = null where pid = xxxxxxxxxx and sdid = xxxxxxxx

commit

-- If wrong chart document, select rollback before executing commit
rollback

Posted : August 20, 2015 11:29 am

Share:

24 Forums
9,942 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0