As the result of the macro, the script variables containing field values will be generated. In the example above the variables ^_users_name=Fred, ^users_id=fr and _users_description=Chief Editor where _(table_name)_(column_name). If the table_name + column_name are longer than 28 characters the variable name will be truncated to 30 chars (28 + 2 '_'). The values are read from current positions in the internal table table_name.

It is worth noting that since support for Perl was introduced in version 7, it is possible to use various freely available Perl modules to perform various database activities if you are already experienced in or prefer to use Perl.