Knowledge Base



KB10872 - Using ViewFeatures on SQL layers.

When using the layer.ViewFeatures property, a complicated sub-query can be sent to the database to narrow the dataset.

By setting ViewFeatures to a non-empty string, the build in TableFeatures is disabled.

Example:
ll.ViewFeatures = "MyView"
ll.ViewFeatures = "(select * from lwaters_FEA where lwaters_FEA.UID IN (SELECT UID from lwaters_FEA where name like 'a%') )"

Note:
Selection should return the shape UID number, like a standard TableFeatures returns. The result of the ViewFeatures will be joined with the TableGeometry on UID field.
Created: October 05, 2011, Modified: October 05, 2011