InterSystems Caché is a multi-model DBMS and application server
Forgive my lack of understanding, but I am working on a vendor created Cache database and the indexes specified in the classes for ODBC connections are not working. A few of them are created, but of the 50+ classes we have, only a handful of them are created when the class is compiled, yet no errors occur.
Example 1:
.png)
.png)
Example 2:
Hello
I need to create an excel file from some data
There are some examples of the same dated from 2016 on the posts but they don't seem to work. Also I think in last 3 years there must be some much better ways which must have come up
Thanks in advance for help
Hi guys,
I have never used regular expressions with caché object script before, so I've read through the documentation, but I am struggling with things that I'd like some help on.
My need is to identify specific html tags and transform them out to something else. Example:
I need to identify those guys in a wider string:
"<span style=\""font-family: '';font-weight: bold;\"" >BOLD TEXT</span>"
"<span font-style:italic;\" >ITALIC TEXT</span>"
Noticed some unexpected behavior when using $ZTH
Resultant values less than 1 are treated as strings and values >=1 are numbers. Causing heartburn in $Query / $Next / $Order loops. Is there a setting somewhere that can change this?
Example:
// Parse the time out of a text string whose format is YYYYMMDDHHMMSSsssssssss (lower case s = fractional parts)
Set MsgDT = "20180405000000001005933"
Set MsgDTH = $ZTH(($E(MsgDT,9,10)_":"_$E(MsgDT,11,12)_":"_$E(MsgDT,13,14)_"."_$E(MsgDT,15,23)),1)
//Do it again, but add a sec to the time string
I am trying to pull the word count from Microsoft Word document into Cache. Is there anyway to get the values of the extended file properties without opening the word document? If I right click on a word document (Word does not need to be installed) I can see the additional properties that I want to reference however don't know how to access these without calling out to VBA or poweshell.
Hi,
I have a project that requires me to post a form. I am following the documention at https://developers.clicksend.com/docs/http/v2/#send-an-sms .
In code I need to be able to do the following:
Is there a way to automatically export all globals? I want to script out this process so that this happens on a specific frequency. This is for testing, as an additional backup safeguard.
Have enabled LDAP for our numerous , Ensemble, IRIS and cache instances with many namespaces. All is working fine and the ldap logins work.
But have noticed that the first instance that the user logs into the namespace is assigned to that user, but when that user than logs into another instance the default namespace from the first login is still there and doesn't update to the new namespace.
So this doesn't effect the ldap login but is now effecting the terminal logins where the user is now getting access denied.
is there a way to send commands to the CMD in windows form COS I would like to run an application within COS by sending a command to the CMD
I have several business operations that are all pointed to the same http server. Is there a way to set the http server within some sort of properties file or within the objectscript code? I want to be able to set the http server setting once rather than for every business operation. Any advice on how to go about doing this would be appreciated.
Curious if there is a string function which can transform a delimited string into an array without looping through $Piece...such as "a,b,c,d,e,f" into array(0)=5,array(1)="a",array(2)="b" etc
I can't do it from the Management portal due. I get a message that DDL is not enabled. So how else do I drop the table?
I have a custom process that is parsing HL7 and inserting it into a table. Periodically the inserts fail with # due to error: ERROR #5803: Failed to acquire exclusive lock on instance of....
Traditional databases would wait until the lock is removed then do the insert, but cache fails. I'm sure it's my coding approach.
How can I work around this? A Try/Catch loop?
Thanks in advance.
I have one persistent, xml-enabled class.
I need to convert objects of this class to XML.
However I need to project each object in different ways (depending on
where I send it), for example:
Is there a way to do that with XML Adaptor?
Someone use gitflow for control of code version? How are doing with production when have many projects?
I have a FullBackup.cbk file generated by Caché Backup Online. This file has many databases.
Is there a Caché feature to restore only one database?
This question is about calling AWS REST APIs. Based on:
http://docs.aws.amazon.com/general/latest/gr/sigv4_signing.html
AWS requires REST clients to call their APIs using Signature Version 4 which in case you don't know what I am talking about is a pain in the neck. Here comes the question:
Has anybody, by any chance implemented the v4 signing alg. in COS? If yes, would she or he have the kind heart to share?
Thanks,
Chris
Hello,
I assume there is a simple explanation for this, but I do get <OBJECT DISPATCH> error, when I am trying to set a global to a value.
My example is huge, but I reproduced it using Samples namespace:
First I delete the Title from ##class(Cinema.Film) - 3
Secondly:
SAMPLES>s ref=##class(Cinema.Film).%OpenId(3)
SAMPLES>w ref.Title
SAMPLES>set ^AK(1)=$G(ref.Title)
SET ^AK(1)=$G(ref.Title)
^
<OBJECT DISPATCH> *Property 'Title' in class 'Cinema.Film' must be MultiDimensional
How to create a CSP Login Page and control user sessions?
Hello all,
I have a Recordset object which contains data from a table "XYZ".
Currently i use this object to extract data using %Get(COL1,COL2...) in a loop and than pass it to a function which inserts the data into another dynamically created Table "ABC" for each record. This takes a lot of time when 100's of records.
Is there a way i can directly copy a RecordSet to a dynamic table without looping through..?
Something like copy Recordset (COL1,COL2..)--> "ABC"
Thanks,
Jimmy
Hi All,
I have a REST dispatcher class in which I enabled the
I can able to access the API using Postman, but not with my web application. It throws the below error.
We are currently trying to implement TortoiseGIT into Cache Studio as per the following Github project
https://github.com/intersystems-ru/cache-tort-git
Our architecture is as follows:
- A server with Ensemble installed on
- Team of several members connect to the server and perform their code build
TortoiseGIT was installed on the server, however, should the REPO location be:
- on the server itself (as a shared path)?
Hi everybody
I'm new in this forum and also new working with a Caché-Database.
Problem:
I have to delete records from a table (by SQL) which contains a field declared as:
Hi everyone,
Im new in cache, i came from Java and im missing some features that i couldn't find in the documentation, I hope you can help me with this questions.
Just a brief introducction:
- Im in a project with old cache version, so saddly i can't use Eclipse + Atelier, so im using Studio.
- Currently im in a project with persistent classes, we want to turn apart the globals and focus on tables.
The questions:
Hi,
recentley we started to work with Atelier & VSTS in our organization .
we are looking for a way to use the VSTS as Our Version/Source control system .
I have read the article about "Continuous Delivery of your InterSystems solution using GitLab" & now trying to find a way to use a similar metodology with the VSTS that we have in our organization.
Hi All,
I have two tables LB_TestSet and LB_Transfer
LB_Transfer has a list if TestSet row IDs, so i am doing the following join
SELECT
LBTS_RowID,
,LBTS_CollectedDate
FROM SQLUser.LB_TestSet
JOIN SQLUser.LB_Transfer ON ($LISTBUILD(LBTS_RowID) %INLIST LBTR_TestSetList)
WHERE LBTS_CollectedDate BETWEEN '2019-01-01' AND '2019-05-10'
Without the date filter the query returns data, but if i add the date filter no data is returned
I also tried using %INTERNAL, %EXTERNAL TO_DATE('2009-01-01','YYYY-MM-DD')
Need a sample of using %Net.HttpRequest and %NetHttpResponse from Cache to retrieve and then use/reuse a bearer token to send json data to a REST web service.