Documentation

Release Notes

2007-06-13

New UI Features

Overall the User Interface has become "snappier", with the following changes:

• FETCH'd columns are now updated via AJAX during data entry in real time, instead of requiring a save and complete page refresh.

• The user's currently selected textbox is now highlighted, giving a visual cue as to where the user is.

• When the user changes a value the background color changes to yellow to provide a visual cue that the screen needs to be saved.

New Properties: uicols and uirows

Columns that are of type "text" are displayed using the HTML TEXTAREA widget. You can now specify the size of the widget with the properties [[uicols]] and [[uirows]].

New AJAX Table Maintenance

When a user goes into a normal screen, they can browse, lookup, do new entries, or skip between entries with things like Next, Previous, etc.

Andromeda will now do all of these screen changes as AJAX calls if you make the following setting in applib.php:

vgfSet('ajaxTM',1);

Speedier System Variables

There is an undocumented system in place for putting variables into the database. The system is defined in andro_universal.add.

To make use of it, give a group read/write access to the "system" module. Then look on the menu for the entry "System Variables". Enter any variable you like, such as "PDF_TOP_MARGIN_OFFSET", which is the name of an option we use in our medical billing program. After you have entered a batch of variables, click on the link that says "Force Cache Reload", otherwise your users will not see the new values.

In PHP code, obtain the value at any time with this command:

$default=0; $x = OptionGet('PDF_TOP_MARGIN_OFFSET',$default);

The system has been sped up by use of the "Force cache reload" system. This writes the entire table out to an associative array on disk, so that regular calls to [[OptionGet]] do not require database access.

More Flexible Foreign and Primary Keys

Before this change, Andromeda had certain limitations on the ability to define automations for foreign key and primary key columns. This limitation came from the fact that we checked keys early, before calculations occurred. We have moved key validation to the end of the validation sequence, making it possible to define primary and foreign key columns as automated columns.

Bug Fixes

• Sourceforge bug 1727555, "Timestamp goes unquoted", fixed.

• Sourceforge bug 1727719, "x_welcome missing
  ", fixed.

• Sourceforge bug 1727497, "infinite loop when table name = module name", fixed. Builder now detects this and stops building, with informative error message.

• Sourceforge bug 1727582, docs inconsistent about "cascade_action" or "cascadeaction". Fixed.

• Popup calendar would not close when a date was selected, this is now fixed.

• On editing screen, if user attempted save and there were validation errors, the system might lose track of the original row. This is fixed.

2007-05-22

New Feature

Support for [[value_min]] and [[value_max]] in a database specification.

Introducing AJAX_X3

The beginning of "AJAX_X3", a general term for all new UI changes that will make Andromeda more like a desktop application. You can turn these on in an application with the line "vgaSet('AJAX_X3',true);" in your application/applib.php file. Note that this was changed in later release 2007-06-14.

The first X3 feature is AJAX fetch. Consider the case where you have an orders line, and the price is FETCHed from the items table. Without X3, the user types in the item code but they do not see the price until they save it and it goes to the server. With X3, the price (and any FETCHed value) is filled in as soon as they enter the item code.

2007-05-18

New Features

• THIS PAGE! Having release notes part of the on-line docs is new with this release.
• LOOKUP MODE: The "ENTER" key now activates the lookup.
• LOOKUP MODE: There is now on-screen help that describes the options
• LOOKUP MODE: Use of ranges, lists, and comparisons
• NEW ENTRY MODE: The "ENTER" key now saves

Bug Fixes

The "More Detail" and "Go Back" links were broken during some experimental UI work. That was corrected.