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

Run Sql Query

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

8 Posts

5 Users

0 Reactions

94 Views

RSS

BGA

(@bga)

Posts: 51

Estimable Member

Topic starter

Can someone tell me the steps I need to do to run a sql query against the Centricity Database.

Posted : December 18, 2018 2:53 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

I have developed a process of executing SQL query within form. If you are interested, let me kniw.

Posted : December 18, 2018 3:03 am

acantu

(@acantu)

Posts: 722

Prominent Member

For CPS you will have to have Microsoft SQL Management Studio to run a script directly, for EMR you will need any tool that connects to an Oracle database. One of these are required to run any scripts directly against a database along with a login that has at least read access.

Posted : December 18, 2018 3:51 am

chaddix

(@chaddix)

Posts: 177

Estimable Member

Sounds very cool - I'm definitely interested in learning more about this.

Posted : December 18, 2018 10:57 am

acantu

(@acantu)

Posts: 722

Prominent Member

Can you provide a screenshot of what this form my look like? Hopefully security has been applied as someone may do some damage to running queries or maybe deleting or inserting records and not really understanding the issues that may occur by doing so.

Posted : December 19, 2018 5:43 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

There is no user facing interface. The function is designed to reside inside the code of a form and return data based on a hard-coded SQL statement.

Posted : December 19, 2018 10:52 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

The simplest solution is to use Crystal Reports.

Posted : December 19, 2018 10:56 am

vrdlc

(@vrdlc)

Posts: 135

Estimable Member

I am also very interested. Can you share this with us?

Posted : December 21, 2018 6:30 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 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