At 10:30 AM 5/11/2005, Jan Johansen wrote:
... is there a way to define the column type in a view. I know normally it picks it up from the table.
Jan,
Try the following steps and see what you get:
01. PROJECT the resulting VIEW to a Permanent or Temporary table.
PROJECT MyNewTable FROM MyView USING ALL WHERE COUNT = 0
02. DROP the VIEW in question
DROP VIEW MyView
03. RBDEFINE MyNewTable and re-define the column types accordingly.
04. Now re-create the View using the same column names, etc., and
see what you get.Hope that helps!
Very Best R:egards,
Razzak.
