Ideally the responses by Jenny Ames and [@Matt Spielman] would have been posted in the "Your Answer" area of DC rather that using the "Add new comment" link. That way  the OP, [@Conor Browne], could accept one of the answers by clicking on the grey checkmark at the top of the answer to turn it green. Doing this helps with DC housekeeping by removing the question from the "unanswered" list.

If Jenny and/or Matthew were to re-post their responses using the "Your Answer" field then Conor will be able to credit one of them with answering his question. Even them posting "See my answer in comments above" would be sufficient to give Conor somewhere to set a checkmark.

Alternatively Conor could either accept my answer (though it's not actually answering his question), or he could post an answer of his own, then accept it.

John, you don't mention it explicitly, but it seems likely that your Cache is running on Windows, and you have enabled the %Service_Telnet service so that your users connect to Cache from a telnet client (which could be Cache Terminal).

In that case, [@Robert.Cemper]'s answer to this post should help you. And if it does, please credit him by setting the checkmark / tick / hook alongside it.

[@Soufiane Amroun], please re-tag your post. Remove the "Developer Community FAQ" tag, which should only be used for FAQ-like postings about how the Developer Community platform operates. Then by adding a tag (or several) that better indicates what your question is about you might get an answer from the Community sooner.

Thanks.

John Murray (one of the volunteer DC Moderators)

Assuming you're using Studio, look at the View menu where there's an option called "View Other Code". This will open the generated INT if it is available. If it isn't, look on your Build menu and pick "Compile With Options". In the dialog that appears, set the checkbox named "Keep generated source code". Then click OK. After compilation finishes, try "View Other Code" (there's also usually a toolbar button for this).

I must admit I was unfamiliar with the xxxFunc() syntax Eduard's code used. So I decided to track it down in the documentation:

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...

That comes from the 2012.2 release notes and reads as follows:

Func() Method Added To Query Classes
A new query member method is available for use, Func. Func() accepts actual values corresponding to the formal parameters defined by the query. It returns an instance of %SQL.StatementResult. When the Func method executes successfully that instance of %SQL.StatementResult is a result set.


If an application has a class with a method whose name is the same as a query name concatenated with "Func", then a member method name collision will be reported at compile-time. Refer to the %Library.Query class for more information.