My choice of a comparison tool was determined by the OS on which Studio is running. But you are free to choose something more platform-independent, such as Java or Qt.

By the way, SQL Data Lens (written in Java) already has the ability to view and upload sources to a file. It would be nice to add integration with a third-party tool for comparing items (by analogy with Studio).

I hope @Andreas Schneider will read this wish.

This Compare only works when working with the studio, correct?

1. uploads the first source code to a temporary directory (for example c:\windows\temp)
2. uploads the second source code to a temporary directory
3. starts WinMerge by passing in the command line links to previously uploaded files: WinMerge Command line

You can do all this yourself from a batch file. In this case, you can compare items not only in different databases, but also on different servers.

Most of the above is true for WinMerge, with one exception - WinMerge is free. WinMerge has plugins for comparing images, PDF, Word, Visio, Excel, PowerPoint, etc.

A good question, to which I do not know a beautiful answer. The option with Extended References, unfortunately did not work.

In general, through uploading to a file. If the elements have different names in the databases, then you can use the Mapping a Routine/Package.

size = 31

ClassMethod Validate(s As %String) As %Boolean
{
 q $MATCH(s,"[1-3].*[A-CRS]")
}

You might find it interesting to download the Community Edition <..> and see if the bugs you reported are still present there or not. What do you think about that approach?

<..> we still create an SU version of Caché <..> because some of our large partners/APs rely on it for people to learn on <..>

And yes, for the sake of hobby, I have been using IRIS CE for a long time.

Hi Jeffrey.

By far the vast majority of users that want Caché are existing customers - so you can get this easily through the WRC.

<..>, until the technical support ended. <..> in future versions of Caché, which I can no longer check.

you could download the Community Edition of InterSystems IRIS and just install Studio from that if you wish

Also, is there a reason you want the SingleUser version of Caché rather than the InterSystems IRIS Community Edition

Maybe there are other reasons why there is still a single-user version of Caché, especially only for those who already have a full-featured version, but for me they are not obvious.

I decided to check the size of the code using an officially allowed method.

ClassMethod length(
  class = {$classname()},
  method = "Solve") As %Integer [ CodeMode = expression ]
{
##class(%Dictionary.MethodDefinition).IDKEYOpen(class, method).Implementation.Size
}

size = 46 (43)

ClassMethod Solve(o As %String) As %Integer
{
 f  s c=$p(o,",",$i(i)) q:'$lf($lfs(o),-c) c
}

ClassMethod Solve(o As %String) As %Integer
{
 f  s c=$p(o,",",$i(i)) ret:'$lf($lfs(o),-c) c
}

So, the author is not lucky and in its version this feature is not available. It seems you have the wrong addressee, I have 2021.2 :)

I also noticed that in IRIS 2020.1 documentation is nothing about 'ALTER COLUMN RENAME' syntax.

After calling

alter table fixxer.decars alter column color rename color2

it became

Property color As %Library.String(MAXLEN = 500) [ SqlColumnNumber = 5, SqlFieldName = COLOR2 ];

It looks like something was fixed in 2021.2.

Good trick!

size = 47

ClassMethod Solve2(o As %String) As %Integer
{
a s c=$p(o,",",$i(i)) g:$lf($lfs(o),-c) a q c
}