Question Jimmy Christian · Apr 23, 2019 SQL CREATE Table Name with System defined variable Hello all, I am still learning CACHE and have below question. In one of my ZEN method i am creating a table using #SQL #Caché 0 2 0 255
Question Jimmy Christian · Apr 19, 2019 Zen DataCombo ListBox ClassQuery not displaying all columns Hello,1)I am trying to have a ZEN datacombo to display list of Namespaces column using a Class Query. #ZEN #Ensemble 0 1 0 196
Question Jimmy Christian · Apr 18, 2019 Running a SQL SELECT statement in USER NAMESPACE to get data from another NAMESPACE Hello,I am trying to run a simple SELECT STATEMENT in USER NAMESPACE.SELECT * FROM projectname.tableWhat is the syntax if i need to get data for a table in another namespace eg. SAMPLES., SYSSELECT * FROM SAMPLES.projectname.table is not working.Thanks in advance.Jimmy Christian. #SQL #Caché 1 9 1 1.4K
Question Jimmy Christian · Apr 11, 2019 SQL Data Import wizard CSP Error Hello, When i click on the menu to run the Data import wizard from MP, i receive following CSP error <UNDEFINED>zOnPageHEAD+229^%cspapp.exp.utilsqleximwizardcontent.1 *schemaname : CSP Error It is happening for all the namespaces. Looks like some permission issue. Same issue with Data Export wizard. Help to resolve this will be appreciated. I am using Cache for Windows (x86-64) 2017.2.2 (Build 865_0_18763U) Thanks, #Data Import and Export #Management Portal #SQL #Caché 0 3 0 307
Question Jimmy Christian · Feb 8, 2019 Studio Terminal Testing Custom Method Hello ,I have a class Method ClassMethod SearchOBXFlag(pSourceMsg As EnsLib.HL7.Message, Identifier As %String) As %String #HL7 #Studio #Terminal #Testing #Caché #Ensemble 0 6 0 570
Question Jimmy Christian · Feb 8, 2019 How to use Object Scripts within Ensemble Rule class Ens.Rule.Definition Hello, I have a Rule Class which receives the HL7 message and sends it to the concerned target based on the condition. #Business Rules #HL7 #Ensemble 0 4 0 639
Question Jimmy Christian · Nov 20, 2018 Pass value from combobox to the altJSONSQLProvider TO update datagrid. Hello ,I want the datagrid to reflect values based on the value i select in the Combobox. How to pass value from the combobox to thealtJSONSQLProvider parameter and reload the datagrid ?My combobox defines below method on change.onchange="zenPage.rowSelected(zenThis.getValue());"<altJSONSQLProvider id="PatchClassJsonId" OnGetSQL="GetSQL" ><parameter paramName="1" value="C"/></altJSONSQLProvider><dataGrid ,......</dataGrid> #Beginner #Caché #ZEN 0 1 0 234
Question Jimmy Christian · Nov 16, 2018 Zen Datagrid save to table Hello all,I have created a simple Datagrid and using jsonSQLProvider with a SQL statement as the datasource. Please see below. #Beginner #Object Data Model #ZEN #Caché 0 8 0 350
All posts
All posts
All posts