Question Stephen Wilson · Apr 5, 2017 Is there an idiot proof walkthrough tutorial for setting up Caché 2013.1.6 license usage monitoring? I know there's a whole chapter on the subject but I would love a super simple video demo or sample configuration or training course. The myriad menu of options and unfamiliar prompts can make it a bit daunting. The challenge is simple. Send an email notification if the license usage exceeds n% LU consumption. Why? A recent software change seemed to be responsible for causing the LU total consumption to reach 100%. #Caché #Monitoring #Tutorial 0 3 0 469
Question Stephen Wilson · Mar 29, 2017 Does anyone have experiece working with ZEN and Web UI Frameworks? (eg bootstrap, W3.CSS) I was wondering if anyone has combined ZEN Web Development with frameworks such as W3Schools W3.CSS Framework or the popular Bootstrap Framework? We are currently using Caché 2013.1.6 so we do not have ZEN Mojo installed which ships in Caché 2014.2 or later. What would be the recommended approach if looking to integrate one of these frameworks? I look forward to hearing your suggestions! #CSS #UI Development #Frontend #ZEN #Caché 0 7 0 657
Question Stephen Wilson · Mar 24, 2017 Can you provide feedback or comments on online course materials? I discovered a possible error in one of the courses but unlike other learning platforms, it isn't obvious how to report it. #Learning Portal 1 1 0 229
Question Stephen Wilson · Mar 24, 2017 Can you create ad-hoc Caché relationship objects? Can you create ad-hoc Caché relationship objects that are not part of the original Caché class definition? One of the drawbacks with relationships is that that the more relationships you have defined, the more difficult it can be manage. I was wondering rather than having all your relationships defined in the Caché class, could you programmatically create relationships between classes as and when they are required? #Object Data Model #Caché 0 3 0 395
Question Stephen Wilson · Mar 14, 2017 How do you use text box filters in tablePanes that have complex SQL behind them? I have a tablePane ZEN Component and I am trying to get a filter running on the Specimen Id / Lab Number. The SQL is fairly complex with 3 UNION ALL statements joining 4 tables and a couple of lookup tables. How would I get the filter on SpecId to work for my tablePane? It's not automatically applying the filter for me so I think I need code something. #Caché #SQL #ZEN 0 1 0 436
Question Stephen Wilson · Jan 18, 2017 ZEN tablePane always selects the bottom row. Why? I have a tablePane that always displays with the bottom row selected. The SQL is executed when the submit/search button is clicked. See attached. Does anyone know how to enable row selection but prevent the bottom row being selected after the button onClick event? #Caché #Frontend #ZEN 0 5 0 389
Question Stephen Wilson · Nov 22, 2016 How do you ensure synchronisation between two %ZEN.Component.tablePane objects? TablePane1 is populated when a %ZEN.Component.button on a form is clicked from a JavaScript onclick method. #Caché #Frontend #ZEN 0 3 0 499
Question Stephen Wilson · Oct 18, 2016 How do you add a Total Phones column populated by SQL COUNT(*) expression in the Zen Quickstart Tutorial? I have been following the online Zen Quickstart Tutorial using the lastest release documentation. In addition to playing around with the styling and making a few minor functionality tweaks, I wanted to add an additional column that shows a count of the number of phone numbers for that Contact (as shown in the image below). #Data Model #Object Data Model #SQL #Tutorial #ZEN #Caché 0 4 0 495
Question Stephen Wilson · Sep 5, 2016 Can MERGE Statements using an $HOROLOG global index cause a race condition? UPDATE: Found a reason in my code why this could be occurring. Still it would be interesting to hear what people come back with.Consider the following MERGE statement. #Caché #ObjectScript 1 1 0 317