Skip to content

Tips and Tricks

Important

Take security copies of your Database after any changes are input !!!
Use the Database Backup routine within the System itself to quickly take a copy to the hard disk. See ‘Utilities’ Menu.

  • N.B: On installation of system, the database will contain skeleton entries in various tables as a guide to their use. Some tables will contain records consisting of ‘***’ with “n/a” or “none” values in descriptions.
    These values should not be altered, as they provide a start point to prompt you on selection lists or drop-downs etc.

General:

  • Multiple windows can be opened from within a screen by clicking on the ‘Panel’ icon in the Menu frame toolbar.
  • To deselect an option particularly in drop-downs in the report windows: Right Click mouse on drop-down heading (Coloured Band).
  • Try to avoid using literals/commas/apostrophes in code structures as it can confuse the querying process.
  • Begin Horse names and owners names etc. with Capital and then lower case to conserve space on lists etc.
  • Right-click in the Horse Window- Main Screen will display each horse’s unique code in the system.

Filter/Sort Feature:

In nearly all reports this facility allows you to override the standard sort sequence and database filters for retrieving data.

  • Example of Filters: Enclose comparison values in quotes: E.G.
    horse_name = “Northern Dancer”.
  • If multiple conditions to Filter repeat the “Filter Argument”
    E.G - horse_name = “Northern Dancer” or horse_name = “Big Jag”
  • If Filtering on dates format must be: date_arrived = YYYY-MM-DD
    Avoid altering the Basic Sorting Keys in a report that has Group Bands:
    E.G Breaks on Stallion/Owner/Location.

Input Screens:

Remember there is no need to press ‘Save’ in the Vet/farrier detail input screens before each ‘Insert’ . Just press ‘Save’ at the end of each sheet or before ‘Close’

Label Prints:

Right Click on Blue Border to Select all clients listed in the selection.

Automatic Nomination Creation:

Nomination records can be created on the fly by entering a nomination number and fee along with relevant stallion in the window ‘ Mare Status Display’