Imagine that your .NET project uses the Caché DBMS and you need a fully-functional and reliable authorization system. Writing such a system from scratch would not make much sense, and you will clearly want to use something that already exists in .NET, e.g. ASP.NET Identity. By default, however, this framework supports only its native DBMS – MS SQL. Our task was to create an adaptor that would let us quickly and easily port Identity to the InterSystems Caché DBMS. This work resulted in creation of the ASP.NET Identity Caché Provider.

Hi, All!

What is the calculated measure expression for the percentage of a member?

Say in Holefoods I want to see in a Cols Online sales in Revenue, All the revenue and % of Online sales for the Revenue?

I have the following:

With expression:

Hello, I've checked past posts and don't see the answer. Hope someone can help.

I'm working with our commercial version of VistA. Cache 2016.2.

I've connected to the instance and copied a few M routines to my local Atelier project. I edited a comment in the file and attempted to save/compile the routine back to the server.

I'm getting

Synchronization failed: Invalid header in /Encounter Interface/VFD.......

Is there something I'm missing? Thanks in advance.

Does anyone has any experiance importing data to Cache which contains special characts like ščž?

I have tried several options, but nothing really works. :)

thanks

NewBie's Corner Session 10 Routines and Studio

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

InterSystems Caché provides a GUI (Graphical User Interface) based Integrated Development Environment (IDE) called Caché Studio. Developers can use Studio to create and maintain applications.

InterSystems has a new IDE called Atelier but that is for later.

I'm trying to connect to server 2016.2.1.803.0 with Atelier 1.0.262
I'm trying to connect using port 57772. The message is "Not Found. Check the web server configuration." when Test Connection pressed. All other connections (management portal, studio, terminal) are working properly.
What I'm doing wrong? Some configuration on server?

marking code snippets as python doesn't enable highlighting for python code

I realize that Cache Studio is the standard method to edit routines. However, some clients make it difficult to access their server that supports Studio. Is there an editor that can be run from the programmer prompt that allows simple WYSIWYG editing of routines? I know there is a %Routine class that you can use to do command-line editing, but I am looking for a full screen editor.

What was the standard in OpenVMS Cache before there was Cache Studio?

Thanks!
Bryan

In an Ensemble 2016.2 production, I put a JavaGateway service. How do you get the console output?

I set the JVM service as Foreground but I don't see any output from Java.

Thanks,

Blaise

Short question: Why are (almost) all Java-Classes marked as deprecated? I never had any problems. And the docu for java-bindings are still (version 2016.2.1) not marked as deprecated. I ask, because in my case everything works and the writing of Unittests is easier than in Objectscript and i cannot find a note about the reason of the deprecation (at least in the classes i have checked).

Have you ever thought what could be a reason why some development environment (database, language) would eventually become popular? What part of this popularity could be explain as language quality? What by new and idioms approaches introduced by early language adopters? What is due to healthy ecosystem collaboration? What is due to some marketing genius?

Take this online course to learn the foundations of the Caché ObjectScript language especially as it relates to use in creating variables and objects in Caché.

Recently I came across a very strong statement to the effect that InterSystems.Data.CacheClient.dll library works fast because it does not open a TCP/IP connection, instead it works in the same process as a database. It made me pause for quite some time. Firstly because .Net Managed Provider, which utilises this library, opens TCP/IP connection to the database (and it is stated in the documentation "Using .NET and the ADO.NET Managed Provider with Caché"). And secondly, because as far as I know only eXtreme applications attach themselves to the process.

How do i do the following:

Pass multiple values from one class to an excel report class using multiple tabs?

I want to request the data in the request class using a SQL statement changing values in the SQL statement, and then parse the values to the excel report to each sheet respectively.

How do I do it?