I am trying to delete a field based on a value in one of the subfields. I would like to remove the below Field with the Field value "Field8". I know how to find the number of fields and iterate. If I just use "" I still get a tilde at the end.

Ex .

|Field^Field1^Field3~Field4^Field5^Field6~Field7^Field8^Field8

I am unable to download Cache Studio from the Intersystems web page. The download link times out.

https://www.intersystems.com/developing-with-intersystems-iris/

Scroll down and click on 'Studio'. Spins then times out.

@Andreas Dieckow can you provide any insight?

Joe

In a typical database, changing the type of a column from some kind of date/time to a string would require a degree of migration effort for existing values. In Caché, my suspicion is that this is not the case, and I could simply change a property definition from %Timestamp to %String (MAXLEN = "30") and recompile, without needing to worry about damaging the existing data stored for this property. Is this correct? Or would I find the existing data in this property being lost or corrupted?

Thanks in anticipation

Hi,

I am getting following error while compiling a routine :

Hey everyone,

We've made a video tutorial for an easy start on InterSystems Partner Directory:

⏯ How to list a company on InterSystems Partner Directory

https://www.youtube.com/embed/WaDUc5dSHhQ
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Hey everyone.

I came across some issues when setting up Freeze and Thaw batch scripts for use with VMWare in a Windows ecosystem, and I wanted to share what I found in the hopes it can help others. This was undertaken in an environment using Healthconnect 2019.1.x.

Hello,

First of all thanks for your time reading our question, and thanks for your replies and help

We would need to know if a patient has less than 65 years old, using their birthday from the PID 7.1

So far we have developed the following code:

Hello, first of all thanks for your time reading this question ◀️

We would need to achieve the following task:

We have a Ens.Response message with this structure:

Hi community,

This is another article about how to perform actions that you can do in the web portal but via code.

Today.... Add a business item in your production by code

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems AI contest!

Date & Time: Friday, July 30, 2021 – 11:00 AM EDT

What awaits you at this Virtual Meetup?

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used. Q&A. Plans for the next contests.

https://www.youtube.com/embed/27vE9o9U3nM
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Dear Experts,

I have to pull out a report of certain code tables and this is my first script and I need to write many.

1. If I have to refer to the table, seeing the reference in the components with reference to SQL table and column,

can I use Select < What I need from the table>

Inner join with reference table?

I tried, I used the code table reference in the components, but I am getting errors,

If one of your packages on OEX receives a review you don't get notified by OEX only on YOUR package.
​​​So @Evgeny Shvarov suggested publishing my monthly summary of reviews here in DC.
It reflects my experience with the status I found at the time of my review.

How strange this is to me. I'm querying a table against a numeric(15,2) column call max_client_resp_service. When I query max_client_resp_service > 0 or any number, I get results, but they are not always right, for example where max_client_resp_service > 5 returns values less than 5, e.g.