InterSystems Caché is a multi-model DBMS and application server
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:
I know &SQL returns only one result but is
&SQL(SELECT ID FROM Cinema.Film ORDER BY ID DESC)
and
&SQL(SELECT TOP 1 ID FROM Cinema.Film ORDER BY ID DESC)
the same in terms of processing required?
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:
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?
%ToJson doesn't work in 2015 release of cache, How to transform a object to json in this release ?
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.
I am reading the following code in ObjectScript:
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:
Hi All,
I have a ZEN report, which gives a PDF output, i want to generate this report programmatically, save to a location in the disk. Here is my method so far
Good Morning! How can I use the method Rewind() to read a file JSON?
Hello,
I am currently trying to create a namespace and I keep receiving error #197 when I try to create the database for it. My OS is Coentos 7.7, my cache version is 2016.2.3.903.6.18300 and here is a screenshot of the error. 
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 |
I am sending a HL7 message from a Service called Servicios.Interconsulta PeticionInterconsultav01r00 to a Bussiness Process Process called
EnrutadorVisa doMedicamento using SoapUI
Hi All,
We have a licensed version of Ensemble but for now, we use only the DB capabilities of Cache. As we create a custom Namespace, for e.g "Test", a new Ensemble Namespace is automically created by the system --"TestENS".
Is there any way where we can identify the system created ENS namespaces ?
Is there a way to estimate compaction / truncation sizes? For a DB when trying to reclaim disk space.
Basically, is there some utility or CLI command that would allow us to estimate if it is worth the effort of compacting a large database or not.
Thanks
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!
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){
