Caché

I used the Activate wizard to create a package for Excel (Activate.Excel). There is a class in there that seems to be what we need to open a file:

Activate.Excel.Workbooks.

 

There is a method that  has an Open() command. I tried  using it but getting an invalid pointer error.

 

The  parameters are as follows:

Last answer 7 October 2019 Last comment 9 October 2019
0   0 1
77

views

0

rating

Hi,

I'm after feedback and comments on the sort of tools and approaches the wider InterSystems community uses for QA Testing applications written in Cache/Ensemble or IRIS.   I am aware of the %UnitTest package, and understand how that works... but:

 

- Do you use an alternative or framework built around this native Unit Testing tool ?

- What is your experience with %UnitTest if you use it ?

- Is there a tool you would recommend for your UI (I know this is not specifically an InterSystems' related question)

Last answer 2 days ago Last comment 1 days ago
0   0 3
90

views

0

rating

Hello!
There is a class query “MemberStatusList” in the SYS.Mirror class that I would like to call from a .NET client application. 
I know that means that there is also a generated class method called MemberStatusListFunc. 
What is the best way if any exist to call them from a .NET application?
Just see if anything responded I tried using something like

IRIS iris = IRIS.CreateIRIS(conn);
var returnValue = iris.ClassMethodString("%SYSTEM.Mirror", "MemberStatusList", "NAMEOFTHEMIRROR")
---

Last answer 1 days ago
0   0 3
54

views

0

rating

Hi All, I am a Data Architect and am trying a method of deploying alter statements onto Cache DB.

My Data Modeling tool generates alters as this.. So question is if the Cache has a way to rename table? If so what is it?

ALTER TABLE <SchemaName>.GROUP_TYPE_NODES RENAME TO GROUP_TYPE_10082019140110000
;

This is giving error.

Last answer 8 October 2019 Last comment 8 October 2019
0   0 1
37

views

0

rating

Hi, we are a veterinary lab and we use both the LAB and FIN systems of Antrim. Now we are looking to expose the data in a SQL/Object compatible way so we were wondering if same / similar things had been done by other community members already? If so, could you please share your approach / experience / gotchas with us and we are all ears. I can be reached at yang.jiao@antechmail.com . Thank you! 

Last answer 13 days ago
0   0 1
0

comments

52

views

0

rating

I have the following message when I try to import a WSDL to generate a SOAP service:

 

ERROR #5319: The type of a property of a class series cannot be recurring: SeleneHL7Service.hl71.escapeType:escape
  > ERROR #5030: Error occurred while compiling SeleneHL7Service.hl71.escapeType class

 

I have found in the documentation:

 

 

5319 The type of a property in a serial class cannot be recursive: %1

 

 

Last answer 12 days ago
0   0 1
0

comments

40

views

0

rating

Hi,

NodeJs(v0.10.0) to Intersystems Cache2014( using cache0100.node)  network connection Not working .

This is error msg i'm getting

"{ ErrorMessage: 'Error loading Cache Library: _SYSTEMcache.dll; Error Code : 126 (The specified module could not be found.)',
  ErrorCode: 1009,
  ok: 0 } "

My Code ->

user.open({ip_address:"127.0.0.1",tcp_port:57772,username: "_SYSTEM",password: "SYS",namespace: "USER"},function(err,res){

    console.log("Error : ",err);console.log("Result : ",res);

    if(!err){

Last answer 7 days ago Last comment 7 days ago
0   0 2
59

views

0

rating

I  am reading the following code in ObjectScript:

GitHub repository
 

And there is a sentence which I am facing difficulties to understand:

    kill ^OPNLib.Game.CWLF(..World)

I know that kill removes variables, OPNLib.Game are the package and subpackage, and ..World is a property. However what does CWLF mean?

You could think that it is the class' name, but it is:

Last answer 10 days ago
0   0 1
0

comments

50

views

0

rating

We have in DB two books, first is loaned because it has the Friend ID, and the other is in the shelf.

I execute a class query to get all loaned books:

    Query BooksLoaned() As %SQLQuery
    {
        SELECT *
        FROM Library.Book
        WHERE Friend IS NOT NULL
    }
 

Which I have tested throught the portal:

Last answer 8 days ago Last comment 8 days ago
0   0 2
97

views

0

rating

Hello,

lets have two  abstract %Persistent classes A,B with NoExtent keyword (storing data in separate globals for each subclass).

Class A Extends %Persistent [Abstract, NoExtent]

{

}

Class B Extends %Persistent [Abstract, NoExtent]

{

     Property Aref As A;

}

Let B class reference the A class. Since the A class has no extent the reference wont work in subclasses. It wont be even usable in SQL.  Is it possible to solve this problem? Whats the recommended way to deal with references/relationships using NoExtent?

Last comment 3 October 2019
0   0 3
0

answers

87

views

0

rating

I am integrating with Front End using ODBC to the Caché tables.

I have a property of type %Library.Time in one of the Caché classes FrontEnd which is in C#, it is not possible in C# to represent only a Time type, it always has a date as well (DateTime type, no Time only in C#), but that is fine, should not be a problem, so for Time the date simply defaults to 1900/01/01. 

Now when this is sent to Caché it does not like it and I would like to understand why because this is causing us not to be able to use a Caché property of type TIME ever.

Last answer 7 days ago Last comment 6 days ago
0   0 3
81

views

0

rating

I was hoping for some input on the best way to deploy code to site with the following criteria:

 - No source code, only compiled code to be deployed.
 - Classes and Routines are part of the application.
 - Data and code reside in the same database.
 - Deployments might be partial updates  (i.e. cannot just send a complete CACHE.DAT).

At present the idea is just to export the .obj, any suggestions?

Last answer 5 days ago Last comment 5 days ago
0   0 2
69

views

0

rating