Is there a command I can use that will do some type of a pass 
through to oracle.

The problem:
I need to get back the current lab statuses on a patient. Every 
time the lab status changes a new record gets entered - we track 
these so it needs to be a separate record.  Ideally I want to 
retrieve the current status for all labs on a patient for the 
current visit where the status on each lab is an ordinal value 
ranging from 1 to 5.

Any ideas

--On Wednesday, July 10, 2002 9:05 AM -0600 Bruce Snyder 
<[EMAIL PROTECTED]> wrote:

> This one time, at band camp, Lanaghan, Kevin M said:
>
> LKM>Is there a way to specify that the max value be returned for
> a  LKM>given query.
>
> Kevin,
>
> The only method of which I'm aware for this type of operation
> would be the max() function. However, the aggregate functions
> have not yet been implemented in Castor's OQL impl.
>
> Bruce
> --
> perl -e 'print
> unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
>
> -----------------------------------------------------------
> If you wish to unsubscribe from this mailing, send mail to
> [EMAIL PROTECTED] with a subject of:
>       unsubscribe castor-dev
>



---------------------------------------
Lanaghan, Kevin M
Vanderbilt University
Email: [EMAIL PROTECTED]

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev

Reply via email to