Adding fields to a view?

[EMJULIAN]

I have a view that I would like to add 2 fields to that I can populate with temporary data. The fields would not be attached to a base table, just added to the end of teh field list of the view and populated with data temporarily. Is this possible?

TIA

Eve

 

[Eguy]

Eve

CREATE SQL VIEW myview AS ;
    SELECT *, ;
    SPACE(15) as dummy1, ;
    SPACE(15) as dummy2 ;
    FROM MyTableName

Will create a local view called myview containing all the fields from the table MyTableName and 2 blank fields 15 characters long.

Ed

Please let me know if the suggestion(s) I provide are helpful to you.
Sometimes you're the windshield... Sometimes you're the bug.