I create a view (CREATE VIEW SOME_VIEW AS (SELECT THIS, THAT, OTHER FROM TABLEA JOIN TABLEB....)), but the view (SOME_VIEW) does not show up in the Table list in the Query Designer/Builder. Are views accessible in Report Builder?
Views are pulled from the database depending on yoru DADE plugin. Open up your DADE plugin unit and modify the GetTableNames method to also return Views as Tables.
Comments
your DADE plugin unit and modify the GetTableNames method to also return
Views as Tables.
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com