Home DADE

Refresh DataView on Data Tab?

edited November 2009 in DADE
In our application Service Release, we ran a SQL statement to rename three
(3) data columns in a Data Table.

Also in the Service Release, we edited the FieldName and FieldAlias values
in the ReportBuilder rbField table.

In the Report Designer ... the DataView on the Data tab displays the
previous FieldName / FieldAlias text.

Is there a way to "refresh" the DataView on the Data tab without having to
delete the existing DataView and create a new one with the Query Designer?

Thanks, Patrick

Comments

  • edited November 2009
    Hi Patrick,

    After you make changes to the fields or tables, try clearing the MetaData
    cache. This should force the refresh of any name changes.

    http://www.digital-metaphors.com/rbWiki/DADE/MetaData/Clear_MetaData

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited November 2009
    Nico,

    Thanks. I tried this, but the DataView still displays the previous data
    field names.

    We have a standalone PrintShop app which allows the user to either display a
    report viewer or to display the ReportExplorer and access the
    ReportDesigner.

    In the application's MainForm.OnCreate is where we placed the
    gMetaDataManager.Clear; statement.

    The daMetaDataManager declaration is in the uses clause of the application's
    MainForm.

    Should I be handling this differently?

    Patrick

  • edited November 2009
    Nico,

    Now I see how it works! The new FieldName and FieldAlias data is displayed
    on the QueryDesigner Fields tab. From there, the user only needs to do the
    following ... yes?

    1. Remove the old FieldAlias from the "Selected Fields" column.

    2. Add (double-click) the desired new FieldAlias from the Available Fields
    list.

    3. Click OK to close the Query Designer and the DataView will refresh.

    4. Go to the Design tab and reconnect data field components with the new
    DataField in the Data Properties inspector.

    Patrick

  • edited November 2009
    Hi Patrick,

    Yes, exactly. When you clear the MetaData cache, you will refresh the
    information the QueryDesigner/Query Wizard shows. The actual DataView
    information is saved down with the template so if the field names/table
    names change, they will need to be updated.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.