View Full Version : 2 questions - remember I'm slow ...

05-05-2007, 09:09 AM
I have a physical table - some rows should not be visible in a business view. There is a single attriubte that determines this. How can I constrain the data in a BT with a where clause?

Is this on the conditions tab of Physical Table properties?


Can I base a BT on a SQL statement rather than a physical table - there are reasons I don't want to use the DBMS to create a view, and would prefer to use a SQL?


05-05-2007, 01:28 PM
We will be adding support for these things in the next version.
For the time being, consider writing views.

We have not added support for these features because we want to cater to the data warehouses first.