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

172

views

0

rating

I have created a view to stage some data in a different format and then want to reference that view in a SQL query from a table that filters the data from the view using a property of the table. 

Example:

select
   MsgId,
   FileName,
   (select
      ReportName
     from
      custom_view
     where
       MsgId = ReportId
    ) as ReportName
from
   main_table

Is this even possible? When I try this, I get an error table not found for the view?

David

Last answer 17 October 2018
0   0 0
0

comments

93

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

159

views

0

rating