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

Problem with case statements.

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

3 Posts

2 Users

0 Reactions

133 Views

RSS

ciaranic

(@ciaranic)

Posts: 7

Active Member

Topic starter

Hi code gurus. I seem to have hit a wall again and I can't see what I am doing wrong.

Some background: I originally made this form without the case conditions and it worked perfectly. I then added the case conditions with L or H adding the L or H to the output and normal results adding nothing. All of the case statements are basically "Case low then, Case high then, else normal" format.

The problem is that it defaults to the "else normal" no matter what I do.

It is kind of unwieldy so I put it on pastebin...

Pastebin - Ciaran's Form Code

Edit: I just noticed the +'s after my HRET's which I fixed but still no joy.

Posted : December 26, 2014 11:09 am

Jim Poulos

(@jpoulos)

Posts: 118

Estimable Member

Ciaran,

I have copied the first CASE statement and see one thing that could be a possible issue. You have a CFMT(WBC) + FMT(WBCUNIT) FMT(L) +FMT(RANGE) .... There appears to be a '+' missing between the WBCUNIT and L format functions. I have bolded / italicized the text below to make it more visible.

COND
CASE DOCUMENT.WBC < WBC_LOW
CFMT(str(DOCUMENT.WBC), "B", "WBC: \t\t","","") + FMT(str(WBCUNIT),"") FMT(" L","B,U") + FMT(WBCRANGE,"") + HRET +
CASE DOCUMENT.WBC > WBC_HIGH
CFMT(str(DOCUMENT.WBC), "B", "WBC: \t\t","","") + FMT(str(WBCUNIT),"") FMT(" H","B,U") + FMT (WBCRANGE,"") + HRET +
CASE (DOCUMENT.WBC < WBC_HIGH) AND (DOCUMENT.WBC > WBC_LOW)
CFMT(str(DOCUMENT.WBC), "B", "WBC: \t\t","","") + FMT(str(WBCUNIT),"") + FMT(str(WBC_MARKER) + FMT (WBCRANGE,"") + HRET +
ENDCOND

Posted : December 26, 2014 4:35 pm

ciaranic

(@ciaranic)

Posts: 7

Active Member

Topic starter

Thanks! Between that and a missing + I got it to work.

It's always a simple little thing isn't it? 🙂

Posted : January 2, 2015 8:39 am

Share:

24 Forums
9,940 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