Equipment Layouts...General

!DELETEAFTER! | All text in the layout after this flag (and including this text) will be removed
| !EQUIP_IMAGE_INSERT! | Inserts the equipment image at the position of this text. This text will be removed!INSERTSTATUSIMAGE=! | Inserts a status graphic at the position of this text - image is noted after equals. This text will be removed!SETTING=NOSTATUSEDITING! | Setting that disables all status editing!SQL=ENTERSQLHERE! | Replaced with the single-field results of the SQL command!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 merged text (overwriting the merged 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. | |