Is it possible to have a variable indent in the generated code??? {_indent}object lblLabel: TLabel {_indent} Top = 0 {_indent} Left = 10 {_indent}end And that that would result in something like this (with _indent set to 4 spaces): object lblLabel: TLabel Top = 0 Left = […]
Read moreAdding custom functions to Excel
If you are, like me, programming in different languages, maybe you have also noticed that you miss certain functions in a language, which are available in a different language. What I am used to do, is either find a function or functions that perform the same task: Delphi: Dec(i);PL/SQL: i := i – 1; or […]
Read moreOracle SQL Developer also for MySQL
This post on Download Squad pointed me to trying Oracle SQL Developer to connect to my MySQL database on this website. After unpacking the download, I tried to connect but apparently I needed some extra software to connect to MySQL. This link on the Oracle site shows the following table. It appears that the needed jar files […]
Read moreSwitched to FireFox…
I finally made the switch from Maxthon (for tabbed browsing) to Firefox. I needed a couple of extensions, like the mouse gestures extensions, but I think I got all the functionality I liked in Maxthon embedded in FireFox now. After installing FireFox, I decided to take a look at ThunderBird, since my current email application, […]
Read moreTabs in output
By default, when you press the tab-key in the editor, the indent is replaced by spaces. I wanted the generated code to contain tabs instead of spaces, so I have created the following code: An Oracle Stored Function: create or replace function tab_char return varchar2 is begin return chr(9); end tab_char; In the cgml code […]
Read more2007
Best wishes for the new year. And I hope to create some nice blog entries this year 😉
Read moreQnxo 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 moreTime spent in queries
I was working on a problem with one of our reports. The customer said it took too long to get results in the report, something like 5 minutes or more. Of course they want to see their results in the blink of an eye, but seeing the kind of calculation and querying that has to […]
Read moreCleanup 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 moreFunctions 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