Notifications
Clear all
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
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
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
Sounds very cool - I'm definitely interested in learning more about this.
Posted : December 18, 2018 10:57 am
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
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
The simplest solution is to use Crystal Reports.
Posted : December 19, 2018 10:56 am
I am also very interested. Can you share this with us?
Posted : December 21, 2018 6:30 am
