I am trying to use %INLIST in  SQL query using a cursor and the query fails to return results. It appears that the variable I use against %INLIST returns an empty string. All the examples I have seen use result sets and build the query as a string. Is it possible to use %INLIST in a cursor-based query? Below is a a snippet of the code I am using:

Property mylist as %String (MAXLEN="") [InitialExpression = "route1, route2, route3"];

set routeList = $LISTBUILD(mylist)

&sql(DECLARE MyReport CURSOR FOR

SELECT

      ProcessStartDate,

Last answer 3 December 2018
0   0 3
0

comments

138

views

0

rating

Atelier is no longer working for me. I am getting the following error: Could not create the view: com.intersys.eclipse.ui.views.CacheExplorer.

Expanding the details available shows the following below. Has anyone seen this and know how to fix it? I uninstalled and reinstalled the Atelier plug-in but that did not help.

Last answer 20 July 2018
0   0 1
0

comments

141

views

0

rating

Just starting to use Atelier and having problems with making server connections. I have tried both the super server port and the web server port and both fail with either Unexpected end of file from server (Secure connection disabled) or PKIX path building failed (Secure connection enabled). On a different server I get Connection refused: check the web server configuration.

Anyone run into this before?

Last answer 22 February 2018
0   0 3
0

comments

216

views

0

rating