Category Archives: I-Types

I-Types within UniVerse field definitions

MS-Access 2010 and Calculated Fields

The new version of MS-Access (2010) has the ability for calculated fields. You may already know this concept as virtual fields, I-Descriptors, derived fields, or if you are rather long-in-the-tooth; correlatives within U2. So, does MS-Access 2010 have the same … Continue reading

Posted in 4GL, I-Types, Idea!, MS-Access, mvdbs, Techniques | Tagged , | Leave a comment

Mail lists down

The U2 mail lists have been down now since 24th March 08. A couple of emails came through this morning, so I hope that they are back online again. I did send a test email yesterday. This has not turned … Continue reading

Posted in I-Types, mvdbs, Techniques, UniVerse | Leave a comment

Get an F for History

As I am in the process of moving, I am in the middle of the ‘clean and junk’ routine. I found a very old fax, dated 27 March 1991, listing ‘a small sampling of correlatives’ which may be of some … Continue reading

Posted in Code, I-Types, mvdbs, Techniques, U2, UniVerse | Leave a comment

DIY B-Tree’s

While reading through the PICK entry on the wikipedia.org website, I found a link to www.semaphorecorp.com which has code and instructions on writing your own b-tree’s within PICK. It is dated from 1987…

Posted in I-Types, Idea!, mvdbs, SQL, Techniques, UniVerse | Leave a comment

Address indexing

Some years ago, I needed to have a flexible search facility on an address field or fields. The address has stored as STREET (multivalued), SUBURB, TOWN/CITY and POSTCODE. I wanted to be able to search on a word or a … Continue reading

Posted in Code, I-Types, mvdbs, SystemBuilder, Techniques, UniVerse | Leave a comment

Try and Catch

The use of THEN/ELSE came up in the U2 lists. I have always had trouble with these statements as they introduce significant overheads around a simple statement like the OPEN or OCONV. I have always liked the try/catch control structures … Continue reading

Posted in Code, I-Types, Idea!, mvdbs, SystemBuilder, Techniques, UniVerse | Leave a comment