Category Archives: 4GL

Forth Generation Languages.

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

MS-Access and multivalued data

Yes, Microsoft’s access database does multivalues. Well, sort of. Multivalues are only available within MS-Access 2007 and beyond and it is really all to do with MS-Sharepoint; the ability to link or select from a sharepoint field.

Posted in 4GL, MS-Access | Tagged | Leave a comment

Validation SB Style

It would be useful to be able to validate data in a subroutine the same way that SB+ does in a field. The long way is to use the execute routine: [code] CALL SB.PROCESS("V:CUSTOMER.ID.VAL") IF RTN.FLAG NE 0 THEN ...error … Continue reading

Posted in 4GL, mvdbs, SB+ Server, SystemBuilder, Techniques, U2 | Leave a comment

SB+ Report Bug

Using SB+ 5.3.6.365 (/SB.INFO). I have a report which sorts, breaks and displays only totals using a I-Type of (“1′”) to create a counting/totaling field. I sort on a coded short field and then break on an I-Type field which … Continue reading

Posted in 4GL, mvdbs, SB+ Server, SystemBuilder, U2 | Leave a comment

How to read a record in SB+ style

In some situations, I have found that I need to write a routine that is too complicated for SB+. When using a SB+ screen, there is a nice ability to show who has locked the same record with options to … Continue reading

Posted in 4GL, Code, mvdbs, Publications, SB+ Server, SystemBuilder, Techniques, U2 | Tagged , | Leave a comment