Here is a simple shell script to copy your ssh authorization key to a remote machine so that you can run ssh and scp without having to repeatedly login.

#!/bin/sh
# save in file ssh_copykeyto.sh then chmod +x ssh_copykeyto.sh
KEY="$HOME/.ssh/id_rsa.pub"
if [ ! -f ~/.ssh/id_rsa.pub ];then
    echo "private key not found at $KEY"
    echo "create it with "ssh-keygen -t rsa" before running this script
    exit
fi
if [ -z $1 ];then
    echo "Bad args: specify user@host as the first argument to this script"
    exit
fi
echo "Copying ssh authorization key to $1... "
KEYCODE=`cat $KEY`
ssh -q $1 "mkdir ~/.ssh 2>/dev/null; chmod 700 ~/.ssh; echo "$KEYCODE" >> ~/.ssh/authorized_keys; \
chmod 644 ~/.ssh/authorized_keys"
echo "done!"

Recital on Linux 64 bit requires certain 32 bit libraries for installation and/or operation.  It also needs to be installed and configured as the root user, or using sudo for those systems without a root login.

For systems that do not have the xterm libraries installed, please install these to use xterm, or set the DB_TERM environment variable to start Recital from a terminal:

DB_TERM=gnome-terminal; export DB_TERM

This setting can be added to the /opt/recital/conf/recital.conf (text) file to make it available system-wide.

Please note that the Recital ODBC Driver for Linux requires a 32 bit ODBC Driver Manager.

Centos 6:

sudo yum install zlib-devel.i686 pam-devel.i686

(and accept dependencies)
Then run the installer in text mode

sudo ./recital-10.0.3-linux32.bin --mode text

Run Recital with sudo the first time, to set the system filetype compatiblity settings.

sudo recital

After saving the compatibility settings, quit to exit, then run Recital as your preferred user.

> quit
$ recital

RedHat / Fedora family:

sudo yum install zlib-devel.i686 pam.i686

(and accept dependencies)
Then run the installer in text mode

sudo ./recital-10.0.3-linux32.bin --mode text

Run Recital with sudo the first time, to set the system filetype compatiblity settings.

sudo recital

After saving the compatibility settings, quit to exit, then run Recital as your preferred user.

> quit
$ recital

 Ubuntu family:

sudo apt-get install ia32-libs 

In later versions of Ubuntu, ia32-libs is obsolete. The following package should be installed:

sudo apt-get install lib32z1

Ubuntu 12.04 and above also require the following:

sudo apt-get install libpam0g:i386

Then run the installer in text mode

sudo ./recital-10.0.3-linux32.bin --mode text

Run Recital with sudo the first time, to set the system filetype compatiblity settings.

sudo recital

After saving the compatibility settings, quit to exit, then run Recital as your preferred user.

> quit
$ recital

Each Recital table can have one or more data dictionaries to provide a central repository for constraints and other metadata. 

Here's how to set up field validation for a field with a small static number of acceptable values.

Using the example.dbf table from the southwind sample database, validation can be added to the title field to ensure it matches one of a list values.

open database southwind
alter table example add constraint;
 (title set check inlist(alltrim(title),"Miss","Mr","Mrs","Ms"))

The inlist() function checks whether the specified expression exists in the comma-separated list which follows.  An attempt to update title with a value not in the list will give an error: Validation on field 'TITLE' failed.

If you have access to the Recital Workbench, you can use the modify structure worksurface to add and alter your dictionary entries, including a customized error message if required.

Recital 10.0 introduced the COPY DATABASE <name> TO <name> command.. The full syntax is;

COPY DATABASE <name> TO <name>  [ IF [ NOT ] EXISTS ] 

This command is used to copy an existing database to a new database. By default an error will be returned if the target database already exists. Specifying the optional IF NOT EXISTS keywords no error will be returned if the target database already exists. If the optional IF EXISTS keywords are specified and the target database already exists, then it will be removed before the copy. Both the databases must be closed before they can be copied.