John Murray · Sep 1, 2017 go to post

What does your $$$AssertEquals macro do?

Both that macro and your WriteCapture classmethod get turned into INT code at some point, and you can view this from Studio if you make sure class compilation preserves INT. Maybe if you post the relevant INT fragments here someone will be able to spot why the presence of $$$AssertEquals is breaking things.

John Murray · Aug 31, 2017 go to post

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.

John Murray · Aug 30, 2017 go to post

Setups are managed in the Security subsection of the System Administration section of Portal.

Key documentation is at http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…

Parts specifically relevant to SQL access to data include:

John Murray · Aug 29, 2017 go to post

Since 86400 is the number of seconds in one day, did you mean to write "it will run every day" rather than "it will run every two days"? Or have I misunderstood something?

John Murray · Aug 29, 2017 go to post

It'd be easy enough to write a method that notes the current collation of locals for the process - ##class(%Library.Collate).GetLocalNumber() - and if it's not 5 (the number for "Cache standard") then temporarily set it - ##class(%Library.Collate).SetLocalNumber(5) - before doing the ]] test, then reinstate the noted collation if necessary.

John Murray · Aug 29, 2017 go to post

This is a good point. I was relying on the doc at http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY… being correct when it says:

Binary Sorts after tests whether the left operand sorts after the right operand in numeric subscript collation sequence. In numeric collation sequence, the null string collates first, followed by canonical numbers in numeric order with negative numbers first, zero next, and positive numbers, followed lastly by nonnumeric values.

John Murray · Aug 24, 2017 go to post

There's a hyperlink at the top of part 2 above. Maybe it wasn't there when you first looked.

John Murray · Aug 24, 2017 go to post

Per the OP's comment here, in this case it's an 8-bit Caché instance, so Unicode characters aren't available on the server.

John Murray · Aug 24, 2017 go to post

Per the OP's comment here, in this case it's an 8-bit Caché instance, so Unicode characters aren't available on the server.

John Murray · Aug 24, 2017 go to post

Yes, that's a DC limitation at the moment. One workaround is to copy the link from the hyperlinked word "Comment" at the foot of whichever comment you consider to be the answer, then add a new answer that references this, e.g.

 

Answered by this comment.

Then you can accept your own comment.

John Murray · Aug 24, 2017 go to post

Uri, I assume your two references to %GSIZE above are supposed to say %GSET.

ISC published information about %GSET the past, and documented it being renamed to %SYS.GSET at 5.1. I think it's a pity they now consider it only to have been 'internal'.

John Murray · Aug 22, 2017 go to post

Judging by this subsequent post by [@Mike Kadow] he resolved this issue. I'm posting this answer so his question no longer reports as having no answer.

This link posted in a comment by [@Joyce Zhang] is a good resource for Mike's problem.

Mike, please set the checkmark against this answer, or any other that may appear, so as to mark the question "answered" in DC.

John Murray · Aug 22, 2017 go to post

Are you running a Unicode version of Caché? If you're not sure, post your $ZVERSION string here.

John Murray · Aug 22, 2017 go to post

Uri, when you get an answer from WRC please come back here, post it as an answer to your question, and set the checkmark against your answer so the DC question shows as "answered".

John Murray · Aug 22, 2017 go to post

Looks like this functionality was moved to a routine named %GSET.

At least, in earlier versions (I checked 2008.1) the %GOF utility used %SYS.GSET but in newer ones (I checked 2017.1) it uses %GSET.

John Murray · Aug 21, 2017 go to post

Good to hear Rubens helped you Coty. The best way of giving him due credit on DC is for you (as OP) to set the checkmark alongside his answer. Look for it above, in the area I've highlighted in my screenshot below:

John Murray · Aug 21, 2017 go to post

Please give us more context. Where is the question arising from? It looks a bit like a homework assignment after a class covering a specific area of the COS language.

John Murray · Aug 18, 2017 go to post

Nancy, to help with DC housekeeping, please re-post your comment as an Answer, then set the checkmark against its title so your original question disappears from the "no answer" and "unanswered" views.

John Murray · Aug 18, 2017 go to post

I guess I could add a little backdoor into this method as well; a screen door, if you will, on my back door.

A smart catflap? laugh

John Murray · Aug 17, 2017 go to post

Thiago, maybe re-post your Comment as an Answer. That way the OP can set the checkmark alongside your answer, so the question no longer lists as "unanswered". Plus, you get credit.

John Murray · Aug 17, 2017 go to post

Tom, maybe re-post that information as an Answer rather than a Comment. Then you can accept your own answer (set the checkmark alongside it), so your question no longer lists as "unanswered".

John Murray · Aug 17, 2017 go to post

AFAIK we users aren't able to change increase this value. If we could, we might be tempted to set it to a very large value wink

See [@Robert Cemper]'s answer for how you can decrease it.

John Murray · Aug 15, 2017 go to post

Today I am seeing this being caused by a post whose <pre>...</pre> block of SQL code got snipped part way through. No </pre> tag got added, so the rest of the page is monospace font.