All
Accepted answers
Vitaliy Serdtsev · Apr 7, 2022 go to post

We need to look at your full code, since there is nothing suspicious in the specified piece of code. I made a small example and there is no highlighting of the last line:

 

Source code

Class dс.test Extends %ZEN.Component.page
{

XData Contents [ XMLNamespace = "http://www.intersystems.com/zen" ]
{
<page xmlns="http://www.intersystems.com/zen">
  <tablePane
      width="1200px"
      id="ItemsTable" 
      OnCreateResultSet="GetLog"
      maxRows="20000" 
      pageSize="20" 
      showRowNumbers="false"
      showRowSelector="false"
      showZebra="false"
      valueColumn="ID" 
      nowrap="false"
      showValueInTooltip="true"
      showFilters="true"
      autoExecute="true"
      initialExecute="false"
      useSnapshot="true" 
      onselectrow="">
  <parameter />
  <parameter />
  <parameter />
  <parameter />
  <parameter />
  <parameter />
  <parameter />
      <column colName="Sit" header="Sit name" width="50%" style="text-align:left;" filterType="text" filterOp="[" />
      <column colName="Label"  header="Label" width="10%" filterType="text" filterOp="["/>
      <column colName="userno" header="Packed By" width="10%" filterType="text" filterOp="["/>
      <column colName="LogedDate" header="Packed Date" width="10%" />
      <column colName="LogedTime" header="Packed Time" width="10%" />
      <column colName="TimeSpent" header="Spent Time" width="10%" style="text-align:left;"/>
    
  </tablePane>
  <tableNavigatorBar tablePaneId="ItemsTable"/>
</page>
}

Method GetLog(
  ByRef pSC,
  ByRef tParams)
{
  s sql = 5
  s sql(1)="SELECT 0 ID,'Sit' Sit,'Label' Label,'userno' userno,current_date LogedDate,current_date LogedTime,null TimeSpent"
  s sql(2)="union"
  s sql(3)="SELECT 1,'Sit','Label','userno',current_date,current_date,null"
  s sql(4)="union"
  s sql(5)="SELECT 2,'Sit','Label','userno',current_date,current_date,null"

  s st=##class(%SQL.Statement).%New()
  s st.%SelectMode=2
  q ##class(%SQL.Statement).%ExecDirect(st,.sql)
}

}
Vitaliy Serdtsev · Apr 7, 2022 go to post

I confirm (used the following code):

#include %systemInclude
n
try{

  s sql="select * from (select 0 field union select 1) where 0=1"
  
  #dim rs As %SQL.StatementResult=##class(%SQL.Statement).%ExecDirect(,sql)
  w rs.%SQLCODE
  
  s st = ##class(%SQL.Statement).%New()
  $$$ThrowOnError(st.%Prepare(sql))
  s rs = st.%Execute()
  w !,"---",!,rs.%SQLCODE
  
  &sql(select * from (select 0 field union select 1) where 0=1)
  w !,"---",!,SQLCODE

}catch(ex){
  w "Error ", ex.DisplayString(),!
}

Output:
0
---
0
---
100

Quote from the documentation:

When retrieving results, first check for successful execution by examining %SQLCODE. For many statement types, success/failure is all that is needed. The %SQLCODE property contains the SQL error code value. Successful completion values are 0 (successful completion) and 100 (the operation has either found no data or reached the end of the data).proof
Vitaliy Serdtsev · Apr 5, 2022 go to post

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.

Vitaliy Serdtsev · Apr 5, 2022 go to post

Can we find out what you need it for?

See Collation

Example:

s sub1=##class(%Collation).SqlString(111),
 sub2=$system.Util.Collation(444,8)
     
k t
s t(sub1,sub2)=""
s t(sub2,sub1)=""
zw t

Output:

t(" 111"," 444")=""
t(" 444"," 111")=""
Vitaliy Serdtsev · Apr 5, 2022 go to post

This Compare only works when working with the studio, correct?
Yes, Studio does the following:
  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.

Vitaliy Serdtsev · Apr 5, 2022 go to post

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.

Vitaliy Serdtsev · Mar 17, 2022 go to post

You can use Caché SQL Gateway (Link Table via JDBC or ODBC)
This, your data migration query will be of the form:

insert into mssql.table(field1,..,fieldN) select field1,..,fieldN from cache.table

Or use third-party utilities to migrate data from/to any DBMS via JDBC/ODBC, for example SQL Data Lens (aka Caché Monitor): Local query cloud (there is a video)

Also there the Bulk Export

@Andreas Schneider - the author of this tools

Vitaliy Serdtsev · Mar 7, 2022 go to post

size = 31

ClassMethod Validate(s As %String) As %Boolean
{
 q $MATCH(s,"[1-3].*[A-CRS]")
}
Vitaliy Serdtsev · Mar 7, 2022 go to post

size = 30

ClassMethod Validate(s As %String) As %Boolean
{
 q "ABCRS"[$e(s,*)*123[$e(s)
}
Vitaliy Serdtsev · Mar 4, 2022 go to post

It is worth mentioning that the "DATEDIFF" function does not always calculation as expected, eg:

>w $system.SQL.DATEDIFF("yy",$zdh("31.12.2022"), $zdh("01.01.2023"))
1
>w $system.SQL.DATEDIFF("mm",$zdh("31.12.2022"), $zdh("01.01.2023"))
1

This is stated in the documentation for SQL DATEDIFF

Vitaliy Serdtsev · Mar 4, 2022 go to post

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 <..>

I have already written that, as well as your large partners/APs who prefer to stay on Caché, IRIS does not interest me in this case. Why would I check something that I won't be using in the foreseeable future, even if there are fixes there?

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

Vitaliy Serdtsev · Mar 4, 2022 go to post

Hi Jeffrey.

By far the vast majority of users that want Caché are existing customers - so you can get this easily through the WRC.
I have indicated why I already can't get Caché now, even the SU version:
<..>, until the technical support ended. <..> in future versions of Caché, which I can no longer check.

Vitaliy Serdtsev · Mar 3, 2022 go to post

you could download the Community Edition of InterSystems IRIS and just install Studio from that if you wish
That's exactly what I'm doing now. But agree, downloading hundreds of megabytes for the sake of Studio and drivers is inefficient.

Also, is there a reason you want the SingleUser version of Caché rather than the InterSystems IRIS Community Edition
IRIS does not interest me in this case. Over the years I have "tormented" WRC about the bugs I found in Caché (in some way I acted as a free beta tester), until the technical support ended. Some fixes at that time were included only in future versions of Caché , which I can no longer check. I would be interested to check out these fixes on the free version.

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.

Vitaliy Serdtsev · Mar 3, 2022 go to post

Do I understand correctly that Caché Evaluation and IRIS Studio (full kit) are only available through WRC, which is not available to everyone, but only for supported customers? It seemed to me that these products are designed for everyone. By the way, the same goes for ODBC, JDBC and CSPGateway.

Vitaliy Serdtsev · Feb 9, 2022 go to post

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
}
So,

size = 46 (43) 

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

Vitaliy Serdtsev · Feb 9, 2022 go to post

In my opinion, the best thing is the built-in documentation, where there are Articles, Guides and Tutorials (see "Document Type" at left)

E.g.: Caché Tutorial Topics Map

Many examples for different technologies/languages can be found in folder install-dir\dev

In a standard Windows installation of Caché, install-dir is C:\InterSystems\Cache.

Vitaliy Serdtsev · Feb 9, 2022 go to post

Are you trying to localize a product created by InterSystems? If so, it is better to contact the WRC.

Vitaliy Serdtsev · Feb 3, 2022 go to post

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 :)

Vitaliy Serdtsev · Feb 3, 2022 go to post

I won't be able to check for version 2020.1 since I have 2021.2.

Try to make a DROP COLUMN and then ADD COLUMN (of course according to the documentation for your version)

Vitaliy Serdtsev · Feb 3, 2022 go to post

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.

Vitaliy Serdtsev · Feb 3, 2022 go to post

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
}

Vitaliy Serdtsev · Feb 3, 2022 go to post

I have 190 on 1 line.

UPD: Program can be reduced to 189, but at the same time efficiency will decrease. Therefore, I will stop on the value 190. Let us know when the contest ends and it will be possible to open the sources.