InterSystems Developer Community is a community of 23,657 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more
Question
· Dec 10, 2017
Cache and Database

Hi, I'm a student, weak programming. I ask for your help, I write a program in C #, there are two tables, but I do not understand how to organize the connection between them many to many. Table in DataGridView1 from DataSet1 on Form1 key connection in DataGridView1 from DataSet1 to Form3

I do this on Form1

0 1
0 435

Has anyone tried adding syntax highlighting to GitHub for Caché CLS files?

Looking at the list of supported languages and extensions...

https://github.com/github/linguist/blob/master/lib/linguist/languages.yml

It looks like Mumps is supported, and there is also an existing language with a .cls extension, which would account for why I see some very odd highlighting going on with some of my code.

There is a page on contributing a new language here...

1 6
0 452
Question
· Dec 10, 2017
SQL IN OPERATOR

Hi,

I'm trying to use the IN operator in SQL.

does not work, can anyone tell me why that could be?

for example:

SELECT * FROM TafnitCore_Logistics_TransferPackage_DB.PackageData WHERE ID IN ('1||1||9852553062' , '1||1||9852553061' ) ORDER BY Building

And I get the following error:

0 3
0 494
Article
· Dec 9, 2017 1m read
Simple Game Code(21 sticks Game) 
sample
    w "Total No.Of Sticks:21"_!
    s sticks=21
    r "enter machine name: ",a
    r "enter dev name: ",b
    w "Display 1 to 21 sticks"_!
    s i=""
    f i=1:1:21{
        w " "_i_" "
    }
user(sticks)
    w !_"User select 1 or 2 or 3 or 4 sticks:"_!
    r "User enter sticks: ",us
    if us>4 {
        w "please select upto 4 Sticks"
        r "User enter sticks: ",us
    }
    s cnt=sticks-us
    s sticks=cnt
    f i=1:1:sticks {
        w " "_i_" "
    }
    s dev=1
    s machine=0
    d:sticks=0 lost(dev,machine)
    d machine(.sticks,us)
    q
machine(sticks,us)
1 0
0 342

I am trying to age based on a given date and current date here is my code:


Property DOB As %Date
Method GetAge() As %Integer
{
   if (..DOB="")
    {
  set today=0 
    }
   else
  {
  set today=$ZDate($HOROLOG,2)-$ZDate(..DOB)
  }
  write "Today's==="_$ZDate($HOROLOG),!
  write today
  return today
}
0 4
0 2.6K
First-class functionwiki

In computer science, a programming language is said to have first-class functions if it treats functions as first-class citizens. This means the language supports passing functions as arguments to other functions, returning them as the values from other functions, and assigning them to variables or storing them in data structures. Some programming language theorists require support for anonymous functions (function literals) as well. In languages with first-class functions, the names of functions do not have any special status; they are treated like ordinary variables with a function type.

This post continues the article “Declarative development in Caché”.

[2, 3, 5, 7, 11, 13, 17].forEach(function(i) {
  console.log(i);
});

How to do something like this in Caché using COS?

Below are some exercises on this topic.

2 0
0 495

Hi, Community!

Please welcome a new session recording from Global Summit 2017:

Building Effective Analytic Data Models

https://www.youtube.com/embed/oBZLRVvuWjc
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 298

Does anyone in the developer community have experience implementing a customized SDA3 container within HealthShare? There is a course on the learning site (ISC1086) that discusses how to do this, but it's currently listed as "coming soon" and I'm hoping to find some documentation.

1 2
1 1.2K

I have a process that I am trying to duplicate from SQL Integration Services (SSIS) into Ensemble so that the rest of my team can help support any issues that may happen.

This particular job creates multiple dictionary files, but for each one of the dictionary files it creates, it also creates a control file that tells the vendor what to process.

0 1
0 500

Hi, community

i've a problem with my production , it works since two months ago , today i can't start it , i don't know where is the problem !!!!

I enclose here screenshots for my production configuration .

thank's

0 4
0 586

Hi,

a Customer of ours comes up with a requirement to improve an existing email business service within one of his ensemble productions. The services fetches emails from a mailserver on a daily basis and extract attached files from this email and send them along with some meta information through the production.

0 3
0 464

I started with the Atelier Stand Alone.

Now I have moved on to Atelier as a plug-in to Eclipse.

With the Stand Alone I had access to two help topics, the Workbench and the InterSystems Atelier.

Now, as a plug-in I have access to a number of other help topics.

When I do a Help Contents, how do I eliminate those help topics I have no interest in?

Or only do a Help Contents on the topics that apply to me as a Atelier user?

I apologize if you have already covered this, but there is so much to read on Atelier already.

0 2
0 268

I have a HL7 schema listed within Healthshare that is marked as 'Standard' however this doesn't appear to not a standard schema and more of a custom one created (there are very specific Z segments within it) that has somehow been marked as a standard. Is there a way to change it from a Standard to Custom? I realise that this cannot be completed within Healthshare but is there a way to change this within Studio?

Thanks

0 1
0 332

Hi, Community!

Please find a new session recording from Global Summit 2017:

Building Durable APIs: New REST Tooling

https://www.youtube.com/embed/Iv1t1znzZyk
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

3 7
0 468

Hi Guys,
Can you please guide me to get rid of this issue. Please find the image files with this post.

Please let me know, before we are developing an API what are all the setup/Configuration(Apache/web server) need to do in my machine.

If any lead would be appreciated.

I don't know, in XMLNamespace parameter which URL need to use.

.

Thanks,

0 3
0 553

You probably have a similar experience.
The more I use Atelier the more I miss INSPECTOR that I had in Studio!

First for PROPERTIES that can inherit a variable number of Parameters beyond imagination.
take %XML.Adapter as the most obvious.
next:
Where to find all inherited methods that I eventually want to overload? Take %Persistent as example.

Or where or how can %OnBeforeAddToSaveSet() (the correct camel case) be overloaded ?

15 5
0 667