Download Installing LimsLink EI

LIMS Module – SQL Query LIMS
Method Name – The name of the current Method is displayed. It is not editable.
Over-ride global connection settings
You have the option to over-ride the SQL Query LIMS connection settings as defined via the Preferences
window. When this option is activated, you must define a valid connection via the ‘Configure
Connection‟ button.
Click on the ‘Configure Connection’ to open the SQL Query LIMS Configuration Setup window. Any
values specified in the SQL Query LIMS Configuration Setup window will be stored within the specified
Method, and are not applicable to the entire LimsLink EI configuration.
Editing the SQL Statement
Clicking on the ‘Edit SQL Statement’ button opens the SQL Statement Editor window. Here you can
write an SQL statement to access data from the database.
Figure 6: SQL Statement Editor
All SQL Statements in the SQL Statement Editor contain four distinct parts. All statements will be
formatted as follows:
Description
LimsLink EI User Manual
6