Home Layouts...General

!DELETEAFTER! | All text in the layout after this flag (and including this text) will be removed
| !IMAGENAMEFROMSQL=ENTERSQLHERE! | After the =, the user must input SQL that returns a single text field/text. This text is used to look up a Global Variable from System-Wide Options (last tab) - IndySoft allows for images to be stored in this grid. If the variable is of image type, then the image is returned, and the image is drawn into the layout at the position of the merge text (overwriting the merge text).

An example of usage would be a company custom field with an image name for a common logo (that is used across many companies). So, the syntax in the Layout could be (at the point where you want the image to display):

!IMAGENAMEFROMSQL=SELECT CUSTOM1 FROM COMPANY WHERE COMPANY_NAME = '^COMPANY^'!

Where 'CUSTOM1' is the Company custom field where you are currently storing the name of the System-Wide Options Variable (that is an image). The text above is replaced with the image.

Note: if the above example were used in a Home Layout, then the ^COMPANY^ alias would be replaced with the company currently on the Equipment View | |