Did you know that Caché (and now InterSystems IRIS) has available parser for ObjectScript ?

Well, technically, lexer. It hides under the name of %SyntaxColor class. This class provides API to the DLL used by Studio to do syntax highlighting. As a result if works only under Windows.

Last comment 3 December 2018
+ 3   1 4


+ 3


Interesting anecdote I want to share. Not 100% Caché related, but I hope it would be useful.

When CSP Gateway is configured on IIS, opening CSP Gateway Configuration page is prohibited by default -- as IIS blocks URLs with '/bin' in it.

In our documentation we advise to add <remove segment="bin" /> to applicationHost.config file.
That is correct.

Recently I had problem when manual editing file Windows\System32\inetsrv\config\applicationHost.config has absolutely no effect on IIS.

Turned out (http://serverfault.com/a/599865) IIS was 64-bit and notepad++ that I used for editing was 32-bit.

So, notepad++ instead of saving original applicationHost.config file saved its copy to Windows\SysWOW64\inetsrv\Config and IIS did not see these changes

+ 4   0 0




+ 4


In this article we are going to compare $Increment and $Sequence functions.

First of all, a note for readers who have never heard of $Increment. $Increment is a Caché ObjectScript function which performs an atomic operation to increment its argument by 1 and return the resulting value. You can only pass a global or local variable node as a parameter to $Increment, not an arbitrary expression. $Increment is heavily used when assigning sequential IDs. In such cases parameter of $Increment is usually a global node. $Increment guarantees that each process using it gets a unique ID

Last comment 19 August 2016
+ 14   0 8


+ 14


"Related conversations" section shows only comments number.

 In fact, these topics might also have answers.

For example, on next screenshot there are three topics in Related conversations section (on the right).

All three of them have answers, but they are shown as having 0 comments, thus seem as unanswered.

0   0 0






Ability to view content by particular member is a great feature.

I'd like to propose some enhancements to this:

  • Member content should be accessible from member page. For example, under separate tab.
  • There should be possibility to follow member. For example, I want to be notified every time Evgeny Shvarov posts something.
  • On member content page we should be able to filter by comments/posts/all content.

UPD: I found separate topic for first item of my list:

Last comment 31 May 2016
+ 1   0 1


+ 1


Order is a necessity for everyone, but not everyone understands it in the same way
(Fausto Cercignani)

Disclaimer: This article uses Russian language and Cyrillic alphabet as examples, but is relevant for anyone who uses Caché in a non-English locale.
Please note that this article refers mostly to NLS collations, which are different than SQL collations. SQL collations (such as SQLUPPER, SQLSTRING, EXACT which means no collation, TRUNCATE, etc.) are actual functions that are explicitly applied to some values, and whose results are sometimes explicitly stored in the global subscripts. When stored in subscripts, these values would naturally follow the NLS collation in effect (“SQL and NLS Collations”).

Last comment 10 June 2016
+ 9   0 0


+ 9