#Caché

Hello Everyone,

I was wondering about the best way to initialize several variables, or several lists of variables.

We are running old VB code on a Windows 2012 R2 server.

In the last month the following error has been happening.

      Failure to create CacheObjectConnection.
      Failure in GetClassInfo for CacheObjectConnection

      Factory not connected to server
     Send to Cache' failed

Neither the the code or Cache instance has not changed.

Cache 2017.1.1.111.0

The code:

        Dim bRtn As Boolean
        Dim objCacheObject As Object
        cntr = 1

        Dim factory = New CacheObject.Factory
        Try
            bRtn = factory.Connect(ConnStr)
            objCacheObject = factory.

I have the following class definitions:

Class PET.RadioTracer Extends %Persistent
{
Property TracerName As %String;
}
Class PET.Injection Extends %SerialObject
{
Property RadioTracer As RadioTracer;
}
Class PET.ImageStudy Extends %Persistent
{
Property Injection As array Of Injection;
}
Class PET.ImageFile Extends %Persistent
{
Relationship Study As PET.ImageStudy [ Cardinality = parent, Inverse = ImageFiles ];
Property InjKey As %String;
}

I can refer to the TracerName for a given ImageFile object with the following syntax:
obj.Study.Injection.GetAt(obj.InjKey).RadioTracer.

Given the class name, how could I leverage the %Dictionary API to 

1. Get the ID Key field

2. Check the ID Key field is Integer type.

3. Given a property name, how could I check  there is a UNIQUE constraint/index on it and also the property is Integer type?

Thanks you.

What types of solutions are out there for terminal based applications to output reports to a PDF document?  This is a roll-and-scroll application that has its own scripts for generating reports.  

In times past, terminal emulations have supported the concept of slave printing which seems like it should still be a viable solution.  I know that in previous lives I have been able to do slave printing with software such as ProComm+ by Symantec (not available anymore).

I'm Trying to create a "Windowing Function" In Cache similar to SQL Server. I'm trying to create a Row Number for every account number (Example Below). I know I can use the %Vid function to create the Row Number but I need the row number to reset with every new account number. In SQL Server it would be Row_Number over (Partition by account number order by account number). and Example of what I am trying to create is below.

Hi

I want to get the total amount of time that a process is active or the timestamp that it was created/started.

I tried the %SYS.ProcessQuery class, but I did not find any related information.

Is there any way to get this information from a process?

I'm using Caché 2017.

We are building our CI/CD pipeline. If we remove a cls file in git how we can delete it from Cache?

Hi,

we are moving an existing ZEN-Application to a new version of Caché (2017.2.2). It is a rather old application and we need to do some modifications due to the thightend security of ZEN in this and prior release (we came from 2013.1). One of the changes required is to alter a table Name of a ZEN-Table on the server-side. Anyway this gives us a problem, since we receive an error

ERROR #5001: Client modification of protected property ( tableName) disallowed for security reasons.
SOURCELEMENT: %ZEN.Component.

Hi,

I'm trying to execute a function in a  loop using studio but I'm having an error; "ODBC driver for sql server Invalid precision value"

Any help please?

Example :

for i=1:1:2{

...

SET expression1 = "exec [po_dm].[dbo].[UP_ED_TE_IT] @P__TE_IT_ID = ?, @P__TE_ID = ?, @P__TE_RA_ID = ? ,@P__TE_VAL = ?, @P__LOW_REF = ?, @P__HIGH_REF = ?, @P__LOW_CRI= ?, @P__HIGH_CRI=? "  

set pars(1) = -1
set pars(2) ="A"
set pars(3)= "A"
set pars(4)="B"
set pars(5)="C"
set pars(6)="D"
set pars(7)="E"

set pars(8)="F"

set pars = 8
set status = ..Adapter.ExecuteUpdateParmArray(.tRe,

Hi

I need to query my messages and filter by a XML node.  

In the message viewer it would be Critetion Type = 'VDoc Property Path' and class = 'Enslib.Edi.XML.Document'.

At the moment my query looks like this

SELECT *

FROM EnsLib_EDI_XML.Document

where doctype = 'avc:mydoctype'

I need then to look for 'HeadNode:SubNodeValue'

Anyone who could help me out with this?

Thank you

I have finished my 4th book about Caché and MUMPS. This will probably be my last.

I am deeply grateful and humbled for all the help I have received from this group and the WW Response Center.

You all have something very special going here. 

Unlike most groups like this, you help those who are struggling to get started, that is unique.

Never lose the attitude of graciously helping the beginner. 

=================================================================================

Following is the book cover, available on Amazon or Smile.

Hi,

I'm trying to find the faster way to get the data from a class, and I find it very slow compared to traditional globals. So, I hope some of you can bring some light to me :-)

I have thousands of registers in a class, and to access it quickly I'm going with $o at the index. From there, I get the values using $listget().

Hi ISC Community!

I'm pleased to announce new release of Caché Web Terminal 3.1.4.

What's new:

1. Drag'n'drop to Studio installation: just import xml in any namespace.

2. After import and comilation access your web terminal app on URL  server:port/terminal/.

F.e. localhost:57772/terminal/       

Slash is mandatory.

3. No need to use %CACHELIB anymore - please feel free to update your Caché and continue using CWT.

Download release here.

Source code for view and contribute here.

Post your issues here.  Want to add your own features - fork it!

Featured screencast   (previos version).

Enjoy!

Hello community,

I am pleased to announce version 1.1 of this project. Now Russian 

Hi everyone

I am new to the bpl diagram. I would like to add an if statement that checks whatever an object is null or not.

I guess that: condition='response.Content != null' would not be ok...

I tried to search for this information in the documentation but I didn't find any help.

Do you have any suggestions?

Thanks and best regards

Milena

The following code snippet is a REGEX that validates characters that are not in English, as well as English characters. The class method "test" takes an email address and validates it based on this additional criteria:

Hi I am getting below error while upgrading cache instance. Please suggest.

Error: ERROR #70: *** Error while formatting volume because ERROR #18: failed creating a new volume initializing CACHETEMP, /*****/databases/cachetemp/ - Shutting down the system An error was detected during Cache startup. ** Startup aborted **

Hello there,

I have some problem with inserting date to table using dynamic sql.

I have Country class. This table has relationship with class Continent as parent and child. In addition I have another statistic class where property Country has type of Country class. I get ID such as "1||1" next I execute dynamic sql INSERT INTO Stats(Country) VALUES("_CountryId_"). Then I select Stats table and see that value of Country column is "11") As a result a can't get Country object.

Please advice solution of this problem

Thank you

Hi,

I am trying to create a script to connect to a website and extract all the content of the page. And in future to connect to an API.

But the output is a wonderful blank HttpResponse

Any ideas?

Thanks

Hello everyone,

Im just wondering if there is any possibility to "Listen" to a cache DB? We have our cache DB somewhere else provided by a different company, we are provided the interface to connect to that cache DB so we can extract the cache DB every night.

Im just curious if theres a way to "listen" to the cache DB, so if theres any changes on the table in the cache DB, I could make a trigger to extract the table again.

I know i could just set my ETL every hour or so... but that would extract all the tables in cache DB.

Thanks a lot for any help and information.

Kind regards,

mark

I have a web application and one of the CSP pages contains the following snippets:

<script language='javascript'>
function SubmitForm(pid,sid) {
//code to process form

alert ("study saved");

self.document.location="newpage.csp";

}

<form name="Studyform"  method="post" onsubmit='return SubmitForm(#(SubjObj.%Id())#,#(StudyObj.%Id())#);' >
<!-- form contents -->

The form is correctly processed, the object is saved, and the alert appears, but the new page does not get loaded and I cannot figure out why.

Any suggestions?

InterSystems is pleased to announce availability of a field test version of Caché and Ensemble 2018.1

These kits can be downloaded from the Field Test portal page.

There are hundreds of bug fixes, and several new features, including:

• Microsoft Volume Shadow Copy Service (VSS) Integration
• Support for Microsoft Integrated Windows Authentication for HTTP Connections
• SSH Enhancements

All platforms are available, except Oracle Solaris 10, 11 for x86-64.  

We expect to update the field test kits about once a week, until release.

(Originally posted by @Eduard Lebedyuk on Intersystems CODE, 6/26/14) This code snippet determines the difference between two ObjectScript lists. The class method "test" runs the code, and its parameters are detailed in the comments:

Hi Guys,

I' am using Cache Object Binding for .NET, our Cache Version is Cache for Windows (x86-64) 2010.2 (Build 454U).

How can I set the connection for Cache List of Objects? Here is my sample code.

//CACHEObject as my file generated from OBJECT BINDING

CACHEObject.ContainerImco containerImco = new CACHEObject.ContainerImco(cacheConnection);
CacheListOfObjects<CACHEObject.ContainerImco> lcontainerImco = new CacheListOfObjects<CACHEObject.ContainerImco>();

//Already tried this one but fails

//lcontainerImco.Connection.ConnectionString = "Server=" + Properties.Settings.Default.

As a developer, usually I'm concerned about how my code health is, and how the other coders code can affect to my own work.  And I'm quite sure most of us feel very similar.

In our company we use a Static Code Analysis tool to analyze code for different languages to ensure we are writing high quality and easily maintainable code by following a few best practices in terms of code structure and content. And the question was: why should be different for Caché ObjectScript language?

Hi everybody,

we have some legacy ZEN applications build upon CSS2 style definitions. We moved the application due to an upgrade to a newer version of cache (2017.2.1). Anyway I have in mind that in one of the prior relases css3 style interpretation was enforced by ZEN and you could explecitly tell the framework to use CSS2 by setting a global. Anyway I can´t found any hints in the docs on that. Does anyone of the %ZEN gurus have this in mind?

best regards,

sebastian

Hi,

is there a way to tell Caché to ignore the order of elements when hosting a SOAP-based webservice?

At the moment I keep getting the Error-Code #6237 (Unexpected tag in XML input) when the request is not in the exact same order as defined.

Looking forward for your answers.

Regards,

Thomas

csession can be called with a variety of arguments:

• tag+offset^routine
• tag^routine([parameter-list])
• ##CLASS(package.class).method([parameter-list])

Hi, I want to use linux system to develop cache, but I dont want to use wine, any other way to???