Nested Datalinks

Designer supports Nested Datalinks for each Block Attribute. They can be used to update multiple values within a single attribute or used as a lookup value in a SQL type DataLink.

For example:

Attribute with DataLink: (SELECT DrawnBy FROM Drawings WHERE DwgID = {DwgID})

Here the Keyword DataLink {DwgID} is being used as the value to search for in the DwgID field of the Drawings table.

Another example: how to get access to any data from the InstrumentList:

In the following DataLink the Keyword DataLink {TAG1Key} is unique name of instrument 1 in the loop currently being created/updated. We use that value to lookup a field in the AVEVA Instrumentation InstrumentList table. Here we are returning the value of 'UserField1'.

(SELECT UserField1 FROM InstrumentList WHERE InstKey= {TAG1Key})