SQL and Array Data

There are many examples in InfoWorks ICM of a network object containing an array of data. The most obvious one is the Bends data field, which stores the intermediate (x,y) pairs that define the bends in a link object.

These arrays can take two forms:

• Value - such as Long Integer or Double contains numbers of the same type, such as the Bends data field. You cannot refer to individual elements in these arrays using SQL
• Structure - contains structured data for a sub-object. Each element in the structure has a name and you can refer to individual elements using SQL. However, an element inside a structure may be a sub-array of type Value. Again you cannot access individual values in such an array

Value Arrays

If you carry out a comparison with a value array, InfoWorks ICM will make the comparison with all the elements in the array. This is best explained with an example.

Click on the image below to reveal the example.

Structure Arrays

You can access the fields in a structure array by name and treat them in the same way as any other object field. The easiest way to do this is to use the list in the SQL Field box on the SQL Dialog to choose the data item. The syntax for fields in a structure array is array.field.