Proof is in the pudding. I created the necessary Cache' objects to
emulate a VistA system and now I am able to perform ADHOC queries and
write programs using modern day programming languages. For example I
recently wrote a Mental Health Performance Monitor Web page using a
mixture of html, JavaScript, SQL and CSP (Cache' Server Page). One of
the SQL queries was the following
select VISIT->HOSPITAL_LOCATION->NAME,
PATIENT_NAME->NAME->NAME,
RIGHT(PATIENT_NAME->NAME->SOCIAL_SECURITY_NUMBER,4),
POV->CODE_NUMBER, VISIT->VISITADMIT_DATETIME,
'' RX_DATE,
'NO' MEDS,
PATIENT_NAME->NAME
from TR557.V_POV
where (VISIT->VISITADMIT_DATETIME >= '06/01/2003' and
VISIT->VISITADMIT_DATETIME < '07/01/2003')
AND (VISIT->SERVICE_CATEGORY IN ('AMBULATORY', 'HOSPITALIZATION'))
AND (POV->CODE_NUMBER IN('296.21', '296.22',
296.23','296.24','296.25',
'296.26','296.30','298.0',
'300.4','309.1','311.'))
Once executed the results were presented in a online MS-Excel worksheet
in the customers' web browser.
Question how much MUMPS code would have to be written to generate this
result set and how much additional overhead to get the result set into a
MS Excel worksheet in the customers' web browser?
Those that have animosity against Intersystems are fearful of having to
learn something new and exciting to me.
Terry
SFC, USA, Retired, BACS, MCP
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Robert M. Witkop
Sent: Tuesday, December 21, 2004 11:28 AM
To: [email protected]
Subject: Re: [Hardhats-members] Intersystems
For years I have been attending World VistA meetings, and have quietly
helped those who were interested in knowing more about Cache. I can show
how using objects to expose VistA data can help VistA acceptance. Using
objects not "object wrappers" can provide performance that cannot be
obtained using wrappers.
I have asked. begged and pleaded for the opportunity to present the
technical benifits of using modern technology, but have not been allowed
to present. Yes, I was allowed a short presentation showing some of the
differences between DSM and Cache, but the slot was during the lunch
break.
Yes, VistA can benefit from InterSystems, that is why I am there, And
yes, there are "non-friendlies" who would cut off their nose to spite
their face.
I am an InterSystems representative. To avoid flames, I normally take
questions about Cache off line and repsond quietly. Yet, others could
have used the information as well.
I would love to do a workshop showing how to map VistA to objects, and
use to objects to expose the data as Java, SQL, etc.
If anyone wants to know more about Cache and InterSystems, you must ask
for it. My voice falls on deaf ears.
Bob Witkop
On Mon, 2004-12-20 at 09:57, James Gray wrote:
> I will put it stronger. I wish we could do more to encourage
Intersystem
> and Cache users to post on this list. I personally have been taken
aback by
> the serious animosity toward Intersystems that has been posted on this
list.
> My guess is that it is only a few people expressing a lot of
animosity.
> Jim
>
> ----- Original Message -----
> From: "Nancy E. Anthracite" <[EMAIL PROTECTED]>
> To: <[email protected]>
> Sent: Thursday, December 09, 2004 5:32 PM
> Subject: Re: [Hardhats-members] Crash on D ^ZU
>
>
> I do. ;-)
>
> On Thursday 09 December 2004 10:27 am, Kevin Toppenberg wrote:
> > Bob,
> >
> > ..."lots of animosity against InterSystems"...
> >
> > I prefer the OpenSource solution of GTM, but I would
> > never say that I have animosity against InterSystems.
> > You've always been helpful. I hope others feel the
> > same.
> >
> > Kevin
> >
> > --- "Robert M. Witkop" <[EMAIL PROTECTED]> wrote:
> > > VA employees can get developers licenenses from
> > > InterSystems. Others who
> > > want to develop VistA applications on Cache can send
> > > me an email (off
> > > the group - lots of animosity against InterSystems)
> > > with their
> > > information and I will get it to an account manager
> > > and provide them
> > > with a temporary (renewable) license and licensed
> > > version of Cache.
> > >
> > > On Wed, 2004-12-08 at 20:13, Takahiro Horie wrote:
> > > > I commented out that line. I restarted from Step
> > >
> > > 32 and on Step 38 I ran
> > >
> > > > into a problem.
> > > >
> > > > I'm supposed to add the line "Q 99 ; Dummy return
> > >
> > > for Cache 5", but the
> > >
> > > > source code is:
> > > >
> > > > --- snippet ---
> > > >
> > > > ;To get available jobs from Cache 5.0
> > > > I v'<5 D Q AVJ
> > > > . X "S ZOSV=$ZU(5),%=$ZU(5,""%SYS"") S
> > > > AVJ=$system.License.LUAvailable(),%=$ZU(5,ZOSV)"
> > > > ;Return fixed value not known version
> > > > Q 15
> > > > ;
> > > > PRIINQ() ;
> > > > Q 8
> > > >
> > > > --- endsnippet ---
> > > >
> > > > Do I change the "Q 15" to "Q 99" ? I'm not sure
> > >
> > > what to do.
> > >
> > > > Thanks,
> > > > Takahiro
> > > >
> > > > On Wed, Dec 08, 2004 at 09:16:01PM -0500, Nancy E.
> > >
> > > Anthracite wrote:
> > > > > That appears to come from
> > > > >
> > > > >
> > > > > ;The next line keeps sign-on users from taking
> > >
> > > the last slot
> > >
> > > > > ;It can be commented out if not needed.
> > > > > JOBCHK I $$AVJ^%ZOSV()<3 W $C(7),!!,"** TROUBLE
> > >
> > > ** - ** CALL IRM NOW! **" G
> > >
> > > > > HALT
> > > > >
> > > > > ... so I guess it probably has to do with the
> > >
> > > Cache Jobs and something must
> > >
> > > > > have gone wrong when you did step 38. Can you
> > >
> > > go back and try that again?
> > >
> > > > > On Wednesday 08 December 2004 04:31 pm, Takahiro
> > >
> > > Horie wrote:
> > > > > > I'm trying to install VistA following the
> > >
> > > instructions on for the
> > >
> > > > > > Cache/Windows install guide.
> > > > > >
> > > > > > On Step 91, when I type D ^ZU, I get an error
> > >
> > > message
> > >
> > > > > > ** TROUBLE ** - ** CALL IRM NOW! **
> > > > > >
> > > > > > And the terminal window closes itself
> > >
> > > automatically.
> > >
> > > > > > I tried to re-open the terminal and I entered:
> > > > > > USER>D ^%CD
> > > > > >
> > > > > > Namespace: VISTA
> > > > > > You're in namespace VISTA
> > > > > > Default directory is c:\cachesys\mgr\vista\
> > > > > > VISTA> D ^ZU
> > > > > >
> > > > > > But I get the same error message again.
> > > > > >
> > > > > > Any ideas what to do so I can complete the
> > >
> > > installation?
> > >
> > > > > > Thanks,
> > > > > > Takahiro
> >
> > -------------------------------------------------------
> >
> > > > > > SF email is sponsored by - The IT Product
> > >
> > > Guide
> > >
> > > > > > Read honest & candid reviews on hundreds of IT
> > >
> > > Products from real users.
> > >
> > > > > > Discover which products truly live up to the
> > >
> > > hype. Start reading now.
> > >
> > > > > > http://productguide.itmanagersjournal.com/
> > >
> > > _______________________________________________
> > >
> > > > > > Hardhats-members mailing list
> > > > > > [email protected]
> >
> > https://lists.sourceforge.net/lists/listinfo/hardhats-members
> >
> > > > > --
> > > > > Nancy Anthracite
> >
> > -------------------------------------------------------
> >
> > > > > SF email is sponsored by - The IT Product Guide
> > > > > Read honest & candid reviews on hundreds of IT
> > >
> > > Products from real users.
> > >
> > > > > Discover which products truly live up to the
> > >
> > > hype. Start reading now.
> > >
> > > > > http://productguide.itmanagersjournal.com/
> > > > > _______________________________________________
> > > > > Hardhats-members mailing list
> > > > > [email protected]
> >
> > https://lists.sourceforge.net/lists/listinfo/hardhats-members
> >
> >
> >
> >
> > -------------------------------------------------------
> >
> > > > SF email is sponsored by - The IT Product Guide
> > > > Read honest & candid reviews on hundreds of IT
> > >
> > > Products from real users.
> > >
> > > > Discover which products truly live up to the hype.
> > >
> > > Start reading now.
> > >
> > > > http://productguide.itmanagersjournal.com/
> > > > _______________________________________________
> > > > Hardhats-members mailing list
> > > > [email protected]
> >
> > https://lists.sourceforge.net/lists/listinfo/hardhats-members
> >
> >
> >
> >
> > -------------------------------------------------------
> >
> > > SF email is sponsored by - The IT Product Guide
> > > Read honest & candid reviews on hundreds of IT
> > > Products from real users.
> > > Discover which products truly live up to the hype.
> > > Start reading now.
> > > http://productguide.itmanagersjournal.com/
> > > _______________________________________________
> > > Hardhats-members mailing list
> > > [email protected]
> >
> > https://lists.sourceforge.net/lists/listinfo/hardhats-members
> >
> >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > All your favorites on one personal page - Try My Yahoo!
> > http://my.yahoo.com
> >
> >
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from real
users.
> > Discover which products truly live up to the hype. Start reading
now.
> > http://productguide.itmanagersjournal.com/
> > _______________________________________________
> > Hardhats-members mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/hardhats-members
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://productguide.itmanagersjournal.com/
_______________________________________________
Hardhats-members mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hardhats-members
BEGIN:VCARD
VERSION:2.1
N:Ostrander;Terry
FN:Ostrander, Terry L.
ORG:Department of Veterans Affairs;VHA
TITLE:IT Specialist (Application Software)
TEL;WORK;VOICE:(706) 481-6769
ADR;WORK:;;One Freedom Way;Augusta;Georgia;30904;UNITED STATES
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:One Freedom Way=0D=0AAugusta, Georgia 30904=0D=0AUNITED STATES
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20041123T144113Z
END:VCARD
