Refresh DataView on Data Tab?

rbuser

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

nicocizik

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

rbuser

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

rbuser

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

nicocizik

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