Hi Community!
We want to invite you to join InterSystems Global Masters Advocacy Hub!
The Global Masters Advocacy Hub is our customer engagement platform where you will be invited to have some fun completing entertaining challenges, earning badges for the contribution to Developer Community, communicating with other advocates, and accumulating points which you can redeem for a variety of rewards and special honors.
This post is intended to guide you through the new JSON capabilities that we introduced in Caché 2016.1. JSON has emerged to a serialization format used in many places. The web started it, but nowadays it is utilized everywhere. We've got plenty to cover, so let's get started.
Hi, Community!
Have a question for general discussion.
In ObjectScript we have cls for classes and mac code, which both compile into int code.
Is there any reason when you use mac instead of cls for non-persistent classes?
For me the benefits for cls are:
1. Inheritance and other OOP features
2. Auto-documented code
For mac one visible benefit is easier call in terminal:
do method^Utils(p1,p2)
vs
Hi, Community!
Coding guidelines discussion. Consider you have For with one command in the cycle. Here are the options:
One
For i=1:1:1000 set ^Test(i)=""Two
For i=1:1:1000 {
set ^Test(i)=""
}Same for the "If":
if a set b=aor
if a {
set b=a
}
Your choice? Or maybe even other options?
Cogs Library
Over the next few months I will be releasing a number of open source libraries and tools to the Caché community.
Most of the code has evolved from previous production grade solutions over the years and I am collating it together under a single overarching library package that I am calling Cogs.
Hi Everyone!
As you know Advent of Code 2018 is in full swing! Till the 25th of December 2018 each day 2 programming problems to sharpen your programming skills!
And now we're ready to present great prizes for Members of InterSystems Global Masters Advocate Hub!
I have a simple app which tries to establish a connection with a Cache database instance via Global API for Java:
import com.intersys.globals.Connection;
import com.intersys.globals.ConnectionContext;
public class Assignment {
public static void main(String[] args) {
Connection connection = ConnectionContext.getConnection();
connection.connect("SAMPLES", "_SYSTEM", "SYS");
}
}
The expection I am getting:
The newer dynamic SQL classes (%SQL.Statement and %StatementResult) perform better than %ResultSet, but I did not adopt them for some time because I had learned how to use %ResultSet. Finally, I made a cheat sheet, which I find useful when writing new code or rewriting old code. I thought other people might find it useful.
First, here is a somewhat more verbose adaptation of my cheat sheet:
Hope most of you already familiar with project CachéQuality from @Daniel Tamajon. For those who don’t know about it, it is a static syntax analyzer for your code written for InterSystems products. It may help you to find and solve many different types of issues in your code, and even possible bugs before clients will find it in production. So, with help of CachéQuality you will be able to deliver a better product. You can find the complete list of rules used to check ObjectScript code here.
It was already available in Studio. And now it is also available in VSCode.
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?
Hello!
This article is a small overview of a tool that helps to understand classes and their structure inside the InterSystems products: from IRIS to Caché, Ensemble, HealthShare.
In short, it visualizes a class or an entire package, shows the relations between classes and provides all the possible information to developers and team leads without making them go to Studio and examine the code there.
If you are learning InterSystems products, reviewing projects a lot or just interested in something new in InterSystems Technology solutions — you are more than welcome to read the overview of ObjectScript Class Explorer!
In this article, I am going to give some examples to get your own docker image with InterSystems Caché/Ensemble.
We have put a new modern and responsive UI design on top of our existing product documentation. It is available in a public beta here: http://docs.intersystems.com/beta/csp/docbook/DocBook.UI.FramePage.cls
Please review the new design and give us your feedback.
In PHP, I'm able to utilize the implode and str_getcsv functions to convert a comma-delimited string to a tab-delimited string. The following is an example.
SOLVED
tl;dr how can you tell if a number is really a string
The original question has been updated/improved.
Equality comparisons on floating point numbers will produce different results...
"1.1"=1.1 //is true!
"0.1"=0.1 //is not true :(
This second comparison can be fixed with...
+"0.1"=+0.1 // is true!
Greetings, InterSystems community!
I am pleased to announce that the web terminal project, Caché WebTerminal version 4 gets its release! After long period of enhancing this web application from 2013, it came to the version 4, which features major stability and security improvements, intelligent autocomplete and syntax highlighting, convenient SQL mode and a lot of other useful features.
The goal of this article is to spread the knowledge about this project over the InterSystems community.
I am trying to fetch the data from cache database. But i got the error like "CSP application closed the connection before sending a responce".
Below is the query.
SELECT
CallbackComment
FROM SQ.CBPhoneResult_View Where PhoneDateODBC = '2018-04-09'
I have investigated and found that "CallbackComment" contains the special character single quotes " ' " for one result and due to this i got this error.
In this field data is enter by customer. so we cannot restrict them like Do Not use single quotes.
The DeclarativeCOS project is a heartfelt cry about programming in the COS language.
The purpose of the project is to draw attention of the public to improving the inner core of COS.
The idea of the project is the support of a laconic syntax for cycles and collections.
So what is this laconic something that I have come up with? Welcome to the examples below!
The key concept underlying the project is the declarative approach to writing code. You need to specify WHAT should be used and HOW.
I would like to start a discussion regarding Caché Objects and Caché SQL.
It is my understanding that the creators of Caché Objects see Caché SQL as the reporting arm of Objects and as such SQL is essential to Caché Objects.
I once met a Caché Objects programmer who was writing code to $Order through the Globals because that person thought that Caché SQL was too slow and inefficient. I attempted to convince the person otherwise.
So, what say you? Is SQL essential to Caché Objects?
Or
I'm trying to format a filed, and I need to add leading zeros infront with a length of 4.
Example:
Before: 1
After: 0001
Please note, this article is considered deprecated, check out the new revision over here: https://community.intersystems.com/post/tutorial-websockets
The goal of this post is to discuss working with Websockets in a Caché environment. We are going to have a quick discussion of what websockets are and then talk through an example chat application implemented on top of Websockets.
I have a query string that I am creating programmatically, based on some user inputs. The user might search on 5 fields, or 8 fields, or no fields.
In my sql statment, some of these fields require parameters in the %Execute statement.
For example:
if user picks lastname, sql = "select * from person where lastname = ?"
if user also picks age, sql = "select * from person where lastname=? and age > ?"
I then have these lines of code to create my result set:
set statement = %SQL.Statement
statement.%Prepare
Hi, folks!
Suppose you have a Caché class with %String property which contains relatively large text (from 10 to 2000 symbols).
The class:
Class Test.Duplicates Extends %Persistent
{
Property Text As %String (MAXLEN = 2000);
}And you have thousands of entries.
What are the best options to find entries which are duplicates on this property?
This post is originally posted on GitHub.
This discussion is open to anyone who use or know about WebTerminal project. It is a result of a long story of the project development, testing and maintaining.
The dataCombo property columnHeaders is a comma-delimited list of column headers displayed in the dropdown list.
Comma is a delimiter.
But, if I want add comma to columh header, for instance "House number, apartment" - this is value for header of one column.
How can I escape comma in this case?
"House number\, apartment" - is not working.
Is anyone in the fine community of developers who work with ISC technologies looking at Microsoft's Visual Studio Code offering?
One of Bill McCormick's recent posts about Atelier referred to Visual Studio being considered the best IDE. Granted, Code is far less of a tool than VS, and probably always will be. But it claims to be open source and cross-platform, i.e. Linux and OS X as well as Windows.
I'm aware of two ways to get list of files in a dir:
set dir = "C:\temp\" set rs = ##class(%File).FileSetFunc(dir, , , 1) do rs.%Display()
and:
set dir = "C:\temp\"
set file=$ZSEARCH(dir_"*")
while file'="" {
write !,file
set file=$ZSEARCH("")
}
Yet they bot return only files and directories in a current directory, but not files in subdirectories.
I suppose I call one of these recursively, but maybe there's a better solution?
Currently, when we want to write data to a file that will be viewed in Excel, we parse the data in tab deliminated format to the file and name it with .xls at the end. That is sent to end users via email. They get a warning that the data is not formatted properly (it's not really an Excel file after all) but it does display somewhat correctly as the tabs are understood (this does not work if we deliminated with commas however).
I am working with a client to try and export a set of tasks defined in the Task Manager from one system to another. I am not seeing any API for this. I can query this information in SQL. So I tried to use the Data Export Wizard from the System Management portal in the SQL window. Export was fine. Importing failed with a "can't insert into read only field" error. Looking at the class definition does not help since the implementation details are not visible.
So how would one accomplish this? Export scheduled tasks from one system to another?
hi
I query large mount of rows from one table with JDBC, and will prompt <store> error. I found that it was out of process memory (default 16M, max 49M in version 2010.2) .
so my question is : how to release memory for large mount of rows query? or how to resolve this error?
