home
Product
Support
Everything Else...
What is the Helix Technical Knowledgebase?

The Helix Knowledgebase is an expanding volume of Helix-related information put here with the intention of becoming a living reference of how Helix works and what can be done with it. It is comprised of two principal sections.

Release Notes from different versions of Helix.
These are included especially because they generally cover information on known problems and workarounds. They also provide a chronology of Helix's development.

Working with Helix
This section attempts to answer Helix questions beginning with "How do I do this?" Some of this material has appeared before, some of it is new. If you have a particularly well-documented explanation of a Helix function, please consider submitting it to become part of the Knowledgebase. You will be given full-credit for your entry, even if it is nothing more than a better way of saying something than the way we already say it.

Please bookmark and return to this page often. Be sure to refresh the page to see what's been added since your last visit. Scroll and learn...

Release Notes

What's new in version 6.0.1 (Feature and Bug Fixes)

What's new in version 6.0 (Feature and Bug Fixes)

What's new in version 5.3 (Feature and Bug Fixes)

What's new in version 5.2/5.2.1 (Feature and Bug Fixes)

What's new in version 5.1/5.1.1 (Feature and Bug Fixes)

What's fixed in version 5.0.2 (Feature and Bug Fixes)

Changes to Command Key combinations in 5.1's Design Mode

The User Services Database

We are in the process of integrating several separate application functions, including servers that have historically been used for Technical Support and Sales. As this process progresses, we will be able to integrate more and more useful information in a format that will provide easier access to it.

Now, sales, key information, developer/client registry, emailing capabilities, survey results, feature requests and bug reports will exist in an environment where it will all be easily logged and ttracked.

Working with Helix
Server Management

Monitor Helix Server to Keep It Running

Remote Access Options

TCP/IP Implementation Notes

Changing Esoteric Preferences in Helix Server 6

Database Basics

Backing Up

Relational Database Definitions

How to Report Crashes in OS X native Helix

Helix Networking

FAQ: TCP/IP and Helix Server 6 FAQ page

FAQ: TCP/IP and Helix Server 5.x FAQ page

TS484: Configuring a TCP/IP network for access through a firewall (Helix 5.2.1 or earlier)

TS1048: Helix Client via TCP/IP configuration notes (5.2.1 or earlier)

Memory Management

Understanding and Setting up RAMJet" and Customized Caches (Helix Classic applications)

Known Issues With or without workarounds
Helix 6 Specific

TS1713: Helix Server 6.0 Crash on Data Replace

Lookups in Popups: A Caveat

OS X Specific

How to Report Crashes in OS X native Helix

TS1240: Mac OS 10.3.2 and Helix Startup Conflict

Miscellaneous Mac OS X Issues

Current

TSD22002: Undefined indexes can compound collection damage

TS958: A deleted field reverts to its previous value when entered

TS960: Subform (or list) won't open the selected entry view

TS1042: Deleting an icon results in a damaged collection

TS1648: Design Mode vertical scroll bar disappears in large relations

TS1912: RADE crashes when Locked icons are selected

TS1992: User View Permissions are inadvertently restricted

TS2013: Intermittent Posting Failures

Older Versions

Date Storage in Helix Express 4.5.1 and Earlier

Get Info: Command Keys Inactive In Reference List

D136: Helix Client crash when Helix Server finishes a save

D682: Lookups to constant data inaccurate on open lists

Helix Client 5.2: Helix Client crashes when Relaunching Under OS X

Helix 5.2: Helix Database has Corrupt Fixed Point Data after Reading Logfile

D183: Helix Server 4.5.5 Known Issues

Known Conflicts: Compatibility issues related to Apple and third party programs

"WindowShade" Problem: Collapse a window and buttons don't work when you open it back up

OS X Transition Notes
Views

Changes to View Types

Default & Invalid Field Shading

Sequences

Sequence Behavior Changes in Various Versions of Helix

Misc

Publish & Subscribe, AppleTalk, Save & Log

Tips and Techniques
The Collection

International Resources (Collection Localization)

The Relation

Global Lookup Problems

Open an Icon from within Get Info dialog

Helix Relation Icons

Selection and Display Modes

User Global Relation

When to create a new Relation

The Field

How Can I Easily Load a Bunch of Documents into Helix?

Create Evaluation Applications

5.2 Fixed Point Field Bug Reference

Number Format Note

Uses for Inert Fields

Using Lookups in Dynamic Popups--a Caveat

The Abacus

Abacus Format

Bar Codes

Data Import

Delete Duplicate Records

Delta Hours Tile

Field Validation

Generating Page Numbers in Printouts (i.e., "Page 4 of 7 pages")

Mailing Label Abacus

Numbering Items on a Subform

Range Validation

Rounding in Helix

Round with Percentages

Select a Field, Abacus or Relation

Treatment of Undefined Values

Understanding Time in Helix

Validate Specific Fields on Replace

Validation to Prevent Carriage Returns

Variance and Standard Deviation

The Index

Fragile Index

Query Optimization Note

Subform Index

The Template

Arrow Buttons

Custom Grids

Dynamic PopUps

How to Open a Subform Template from a Host Template

Removing a Subform Template from a Host Template

Use Background Pictures

Using Lookups in Dynamic Popups--a Caveat

The View

Field Shading in Helix Applications (New: July, 2006)

Restricting the Number of Records on a Subform

"Priming" a Delete Dialog in Design Mode

Optimization of Lists Using the Shade Invalid Fields Command

Quick Lists and Quick Entry Forms

Use only one Entry Form in a Relation

The Post

Conditional Posting

Duplicating Records

Forcing the order of Posts

Limit Views for a Specific User

Option and Triplet Posting Sections

Order of Posting Events

Store Text in Upper Case

The Query

Quick Query Options

The User

The Sequence

Sequence Dialog Options

Structure Only Copy of Collection

Helix Diagnostics
Overview

General Questions about the Diagnostic Utilities

Helix Update Collection

Using Helix Update Collection

Helix Utility

Using Helix Utility