Using a Component Table

Previous Next

See Also

Component tables can be used as if they were normal database tables. In all the places within USoft where you can specify a SQL statement you can use component tables. Component tables are allowed in all subqueries (i.e. NOT EXISTS, NOT IN etc). SELECT statements, as well as manipulations, are allowed on component tables, with the following restrictions:

· There is no outer-join support.


· CONNECT BY and START WITH are not allowed.


· At the moment, component tables cannot be subtypes or super type tables.


· Primary key columns of Component Tables are non-updatable. The reason for this is, that it makes the definition of the UpdateRow method easier: it gets parameters for every column. Without the restriction, the old values for the primary key must also be passed to the method.


· Binary data is not supported.


· The STDDEV and VARIANCE functions are not supported for queries on component tables.