Hive group

Welcome to The Hive Group! Be sure to subscribe, and don't forget to click "my subscription" if you want to subscribe to the mailing list.


See also:
The Hive Project
The Hive Project Issue Tracker
The Hive Group Forum


Greasemonkey script to select Progress knowledge center by default

Hi,
I've written a Greasemonkey script to bypass the initial choice for OpenEdge or ObjectStore, DataXtent.
Greasemonkey is a Firefox Add-on.
Install script

Regards
Carl


Internet Explorer 7 breaks the Hive's layout

Just when you think the Hive layout works fine on every browser... meet MS Internet Explorer 7.
I just upgraded to IE 7 today and was unpleasantly surprised how it makes the Hive look a bit silly. The indentation in list items is way too large, which is especially bad for the sideblocks like "Browse by Category". Here's a screenshot:


ProDataSet mimimal case read example

This is a minimal case example of using a ProDataset to marshal data from one TT to another TT. This code was written to demonstrate how a data-source, dataset, and a set of temp-tables are structurally assembled to read data from one table into another table.

   /* Procedure Temp-Tables         */

DEFINE TEMP-TABLE tt-src   NO-UNDO
   FIELD i1    AS INTEGER

   INDEX i-i1     i1
   .

DEFINE TEMP-TABLE tt-tgt   NO-UNDO
   LIKE tt-src
   .

   /* Procedure Variables           */

DEFINE VARIABLE cur-cnt    AS INTEGER     NO-UNDO.

Tool to report index selection analysis for a query

This tool allows you to enter a query on a table, and reports detailed index selection information for you, including an index tree (of one or more indexes) that the compiler would construct for this query, plus an analysis of indexes for each node of the index tree to help explain why each index was chosen.

The source code for this tool (written in Progress 4GL/ABL V9.1) is included in the download. It is quite heavily commented to help explain all the compiler's index selection behaviour (including how/why multiple indexes are sometimes selected). The UI is very simple so it can be used i


Too hard to find the forums

I've come here a couple of times, and finding my way to the forums is too hard.

Shouldn't the discussion area at least rate a tab with home, projects, etc.?


Change the font

Overall this looks pretty good, but those "stylized" orange-font header / title lines are hard to read. Could an easier to read font be used instead?


Proogle: Search Progress sites on Google

Use the Hive's own Google custom search engine to search Progress related sites. The Hive is searched, as well as the domains listed in the White Pages, as well as the Progress related pages and directories listed in User Links.

This search engine is manually maintained by your hard working Hive volunteers.






ConeTree

ConeTree

Registration email and spam filters

Over the weekend we made a change to the Hive's website hosting settings so that reverse DNS works properly, and that should help with spam filtering.

If you never received your registration welcome email from the Hive, then please try "request new password", or else just use the "contact" form to let us know you are having trouble, and we'll send you a password.

I also see from the system's email logs that there are a couple of people who entered email addresses that look perfectly legitimate to me, but the emails are bouncing with "invalid address" type messages. Again, if you aren't getting your registration welcome email, please use the "contact" form to let us know, and we should be able to help you get it sorted out.


Where to put content?

When adding new content to The Hive, there are always two big questions -- what kind of content and where should the content be added. The first question is discussed here. Having picked the type of node or nodes that you want to add, one needs to know where and how to add it. This depends on the nature of the content.

If you are adding multi-part content such as a series of book pages collected into a manual, a series of book pages containing code samples, a project with associated forum, documentation, etc., then the first important point to keep in mind is that one wants one node and only one node from this set to the the top level node, the home, for the whole set. Only this top level node will be added to the site navigation and the rest of the content will be found from there. The Hive editors reserve the right to add new categories and/or switch categories in a way that we feel will make you material most easily found and most appropriately grouped with other related material.


OpenOffice.org Calc Library

This is a collection of functions and procedures that provide an API to the OpenOffice.org Calc spreadsheet application. These were developed in Progress 9.1D using OpenOffice.org version 1.1.2 and have not yet been verified to work with version 2+.

This collection of functions and procedures will allow you to programmatically create Calc spreadsheets, add data, format columns, rows and cells and more!


Creating good "teasers" or previews

When creating most node types there is a section called Description or Body into which one can put a significant amount of text or more complext HTML. When there is a reference to this node following the Browse by Category links, searching, or other forms of site navigation in which multiple targets can be listed on a single page, Drupal will show a "preview" of the node by displaying a paragraph or two from the top of the Body or Description so that one can have a better idea whether or not it is a node one wants to explore. This brings up two important points for creating optimum site content.


Redirect from previous site to the hive

Suppose you already have some Progress-related material on your own website, and decide to move it to The OpenEdge Hive, then you may consider redirecting the old location of that material to the new url.

Redirection prevents you from losing your existing visitors. When you don't redirect you may have the following problems:

  • People may have bookmarked your page. When they visit that bookmark, they just find nothing
  • Many Progress related websites have links to other Progress related websites. I have noticed that links are usually not actively maintained, so when you move a page there will be broken links

HtmlDict

HtmlDict windowHtmlDict windowHtmlDict resultHtmlDict result


#
Syndicate content