#Caché

I know that 1-1 relationships are not officialy supported by intersystems cache/iris so I want to know the best way to store data with this kind of data model.

Currently I have two classes that where implemented some time ago:

Table A with a relationship type one on table B

Table B with a relationship type one on table A

To compile I have a double compile with qualifyer U.

What is the best way to implement a data model with 1-1 relationships?

Thank you

Hi, how do I add the POST body content to my Net.HttpRequ

How do I compile a file through the command line?

I am generating a very basic csp page in a bash shell, it is generating fine and displays what I want to see as long as I go into studio and compile it . This defeats my purpose of having the page and I am having no luck figuring out what I am doing wrong. I think the issue has to do with the file not being included when I compile from command line.

Ver is 2017 running RHEL 7

From command line I see

TST 3f2>DO $SYSTEM.OBJ.Compile("csp.vvmaccessnewrds","h")

We have code with the line

Is there any way to execute many SQL commands at once as an (anonymous)block?

for example in PostgreSQL there is

DO $$

BEGIN

--here is Inserts/Updates/Deletes

END $$

Or in Oracle

BEGIN

END; 

Thanks for the answers!

just wondered if there was a way to pass functions for execution to another function so that events can occur before and after?

like :

d ..MethodA(
   ..Method1("var"),
   ..Method2(0),
   ...
)

edit:

I managed to get it working with execute but is there a cleaner (easier way)?

I am trying to set a varaible/property within JavaScript and use the value in my method. The alert method below returns "0". Do I have the syntax wrong?

/// Storage for current table row

Hi,

call my web service (%SOAP from caché 2012 v) from XmlHttpRequest client generate cors policy error,

Any one help me how i can allow origin in headers requeste.

Thank you.

Hi

I was wondering whether there are any best practices or guidance around converting a HL7 message in to XML stream which will then be delivered to an end-point. Any help would be much appreciated.

Kind Regards,

Salma

Where can I download the Cache ODBC drivers for Windows?

I went here https://wrc.intersystems.com/wrc/Login.csp but it said

User is not enabled for WRC login. If this is unexpected, please contact InterSystems Support.

What does that mean? What do I need to do?

Hi All,

I am aware of some Auditing software that was made available quite some years ago that I cannot find.

I would like to install it and give it a try. Does anyone know where I can access this software please?

Thanks in advance.

Steve

Hello,

We would like to learn how would you approach this task.

We would need to check every day a set of folders which are outside our server (in fact we could see them as if they were "inside" the server), then we need to check for modified or created files in the last day, and move all the ones which match the criteria to just one folder in our server.

We have thought about doing the following:

1) Create a task to run it each day:

Hi Community,

Is it possible to track Application Errors from a specific namespace?

With the new API, I know we have the endpoint /alerts.

But the endpoint /alerts, as described in the documentation:

The /alerts endpoint fetches the most recent alerts from the alerts.log file and returns them in JSON format.

I want to create push notifications for Application errors in specifics Namespaces, and I don't know how to extract that information from there.

Hello,

We would need to iterate all over the OBXs list and get their OBX3 CE1 to determine if it is the lab result we need to send to the output system.

We wonder how could we achieve this in a foreach component inside a Bussiness Process.

We think we would need to use a foreach because of it is needed to generate a message, for each one of the OBX which have the OBX3 CE1 that the output systems uses for the lab results.