All
Accepted answers
Robert Cemper · Oct 23, 2023 go to post

great idea::  integers as separators!

just realized the separating blank broke the line in display.

Robert Cemper · Oct 22, 2023 go to post

I didn't get the meaning of  Field(ge=0) immediately
I see 6 variants to achieve this in IRIS in order of my personal preference

  1. use SQL NULLIF function
  2. use SQL CASE..END block if more complex
  3. use a custom SQL Function = ClassMethod projected as SQLProcedure
  4. create a TRIGGER if this is not just a single case 
  5. use calculated properties with on Change clause
  6. create a customized  OdbcToLogical method 

There are eventually more options  

Robert Cemper · Oct 20, 2023 go to post

First bid:

  • 145 by code checker
  • 35 real code - the rest is text + packing + "cosmetics"
Robert Cemper · Oct 19, 2023 go to post

#1)  Subscript > 511 chars is not allowed

#2) your browser broke the CSPCHD token for some CSP page

Robert Cemper · Oct 12, 2023 go to post

contact ISC sales, buy an appropriate license, and  you get access to WRC and the Kit repo

Robert Cemper · Oct 10, 2023 go to post

If this is your own CSP page you may set  %session.EndSession =1

OR
you have a dummy page that does just this and you call it manually
I did it mostly during testing 

Robert Cemper · Oct 10, 2023 go to post
  • <ROLLFAIL>   rollback of any transaction crashed
  • by <FILEFUL>  your DB or JOURNAL can't be expanded

Check available disk space

Robert Cemper · Oct 10, 2023 go to post

since the invention of Grace Period by BdK  I'm fighting hanging CSP connections.
my approach:

  •  
     

in most cases, it is sufficient to get free locked licenses

Robert Cemper · Oct 5, 2023 go to post

when I worked in Italy and Spain 40+ years back we always went to the cafeteria next door.
They served excellent "café correto".  
BTW: I'd definetly prefer Sangia over Cold Water
😋

Robert Cemper · Oct 4, 2023 go to post

I assume "water cooler tank" has the same social functionality
as the kitchenette with the common coffee machine in central and northern Europe

Robert Cemper · Oct 3, 2023 go to post

Hi @Raj Singh,  @Lorenzo Scalese , @Evgeny Shvarov 

  • I'm fully for developer-to-developer initiatives.
    • though in practice, this is too often developer-to-nirvana 
    •   
  • dark-corner:   
    • several months back I suggested having an ARCHIVE option
    • so that packages stay in OEX but don't show up in the directory 
    • if not explicitly requested similar to SPAM in DC.  
    •  
  • But something like this seems to exist already.
    • My recent update of my OEX web sniffer found 2 packages
    • that do NOT show up in directory.
    • don't ask me how this works but that tool is there somehow.  
    •  
  • The actual critical corners might be identified by a combination of
    • LastUpdate in OEX and pending PR.
    • >>  

 

Robert Cemper · Oct 3, 2023 go to post

I suggest to have globals and routines in separate databases.
Keep the routines always local and only use Global DB over ECP for shared access.
The price is you have routines to maintain in 2 instances.  

Robert Cemper · Oct 2, 2023 go to post

Thanks.
This matches my experience. Issues require explicit Close to vanish from main-page counter.
 

Robert Cemper · Sep 30, 2023 go to post

did you use SQL from SqlShell?
like this? 
USER> Do $system.SQL.Shell()
......
SQL>>SELECT .....

Robert Cemper · Sep 28, 2023 go to post

So I assume an id of 1 will suffice. WRONG

^DocM.DocumentImageD(1,1) =
indicates that the id is "1||1"
therefore after
AVCWS>Set obj = ##CLASS(DocM.DocumentImage).%OpenId(1)
write obj   shows it is NOT and <OREF>
and obj.ID fails as a consequence:
But this is all visible in the class definition of 
DocM.DocumentImage.cls

Robert Cemper · Sep 28, 2023 go to post

Looks like old cached queries don't know new index ???
try drop cached queries from SMP

Robert Cemper · Sep 24, 2023 go to post

Add it to the GitHub package in any case. with a short notice in README.
I have no experience with using ZPM outside IRIS.
 

Robert Cemper · Sep 24, 2023 go to post

OK this is fixed and works fine.
Some hints from personal experience

  • make sure your phone is operational
  • use a fresh API key
  • use an anonymous browser session
  • speak English or American
Robert Cemper · Sep 23, 2023 go to post

Sorry, there is a bug:

from config.py:

# Default config variables
import json
import os
import sys
import base64

APP_PATH = os.path.dirname(os.path.abspath(__file__))
JSON_CONFIG_PATH = APP_PATH+"/config.b64"
.....

BUT it is missing in your repo:

irisowner@2bbb2b066320:~/dev$ irispython ./rh/flask/main.py
/home/irisowner/dev/rh/flask/app/config.b64 not found

Ooops !
 

Robert Cemper · Sep 18, 2023 go to post

No discussion: Business Operation and Outbound adapter is a combination you should not break 

But to trigger a second Business OP You just need a Business Service that you kick,
no need for a Busines Process in between. Old ENSDEMO shows such examples.
eg. DemoRecodMapper

Here the FileService is the driving part.
another example uses a service that triggers itself DemoDashboard

It just lives on his timeout setting
Here it has nothing to do then updating some properties
But it could be anything. eg Kicking another Business Operation