Types of Datalinks

Designer uses two types of Datalinks:

• Keywords. These are always enclosed in curly brackets {}

  Examples:

  {DwgNo}	returns the value of the Drawing Number field for the current drawing.
  {Title1}	returns the value of the Title1 field of the Drawing List for the current drawing.
  {Tag1}	returns the Tag No of the first instrument in current loop (if the current drawing is a Loop Diagram).

  Note: Refer to DataLink Keyword Samples for a comprehensive list of Keyword DataLink definitions used within Designer.

• SQL Statements. These are always enclosed in curved brackets ( ) and are written in the form of a standard SQL (Structured Query Language) query definition for database access:

  (SELECT Field1 FROM TableName WHERE Field2 = Value)

  For example:

  (SELECT ModelNo FROM InstrumentList where TagNo ='FT-600')

  This returns the ModelNo field value from the InstrumentList table where the TagNo field is equal to FT-600).

  Keyword Datalinks are predefined within the Designer and cannot be user defined.

  SQL Statements are user-definable and are included to enable advanced users to access data that has not been defined as a Keyword DataLink.

  Note: To view available Keyword Datalinks for any drawing in the Designer's Drawing List bring up the Datalinks Window.