Category Archives: Qnxo

Qnxo is now Qcgu

Quest has recently aquired Qnxo which they will make available for free on ToadWorld.com. They have also renamed the product to from Qnxo (Quality iN, eXcellence Out) to Qcgu (Quest Code Generation Utility). Since the acronym doesn’t sound too good, it will probably be referred to as CodeGen. I have been testing the new version […]

Read more

Cleanup after yourself

When working with your own arrays in Qnxo, you end up with all kinds of views in the schema that you actually don’t want to be left there. For one because they don’t serve any purpose, except for the CGML code generation, and you don’t want any other code to depend on them, because they […]

Read more

Functions returning Collections

Suppose you have a table and this table contains only one row, for instance a record with some application settings. You have the QDA packages in place and you want to retrieve this single row. But you don’t know what the primary key will be. On your development system it can be something else than […]

Read more

QDA reduces code…

At my office we are building and supporting software for an insurance company. We have chosen for an architecture where there is one request record. This is connected to one or more variance records, which are in turn connected to the type of insurance. There is also a connection to a number of employees connected […]

Read more

Column order

Yesterday I came across a rather strange problem, which was luckily relatively easily solved. The problem is like this: I am using QDA (Qnxo Development Architecture) packages┬áto get to the data in my tables. In the Query Package there is a function to retrieve a row from the table. I had generated this code and […]

Read more