On Sun, 2004-12-05 at 21:59, John Leo Zimmer wrote: > ---------- Original Message ----------- > From: Kevin Toppenberg <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Sent: Sun, 5 Dec 2004 18:14:26 -0800 (PST) > Subject: Re: [Hardhats-members] Need Help Using VistA to Track Patient > Demographics For a Clincal Study > > > VistA has its own database system. It is built on the > > M language, which at it's heart is a database. > > > > If you want to access the VistA data with SQL queries, > > you can do that. I believe GT.M has a SQL interface. > > > > I don't believe GT.M itself does. > > "GT.M’s data dictionary is flexible and adapts easily to international > requirements. SQL/ODBC access to GT.M databases is commercially available." > (from http://www.sanchez.com/news_2000/nr_001107.asp )
That is correct. There are multiple SQL engines layered on top of GT.M. For VistA, I recommend KB_SQL. There is also OQL (Object Query Language) that is provided by ESIOBjects. -- Bhaskar *************************************************************************** This electronic mail transmission contains confidential and/or privileged information intended only for the person(s) named. Any use, distribution, copying or disclosure by another person is strictly prohibited. *************************************************************************** NOTE: Ce courriel est destine exclusivement au(x) destinataire(s) mentionne(s) ci-dessus et peut contenir de l'information privilegiee, confidentielle et/ou dispensee de divulgation aux termes des lois applicables. Si vous avez recu ce message par erreur, ou s'il ne vous est pas destine, veuillez le mentionner immediatement a l'expediteur et effacer ce courriel. ------------------------------------------------------- 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