Rename of Table for reports?

rbuser

Hi Guys,

Happy New Year to All.

I am normalising a database with some 20+ tables.

Several of these tables are used in reports stored in the rbxxx
Tables. The reports are edited/run using the End-User interface and/or
are called from the main application and passed parameters.

All working fine.

I now want to re-name a table in the database that is used in many of
the reports, say 'Invoice' to 'Invoices'. 'Invoice' is currently
aliased to 'Invoices' in the reports.

Question. What is the most efficient method, if it is possible, of
renaming the table in the reports, without having to drop the old and
add the new. and without compromising the report?

I can see in the rbxxxx tables I could simply rename 'Invoice' in the
tables to 'Invoices' but that doesn't fix the Report Template.

Regards & TIA,

Ian

nardmoseley

To update the existing report queries, you will need to edit the templates
as text. This rbWiki article discusses the details and includes links to
downloadable code examples.

http://www.digital-metaphors.com/rbWiki/DADE/Fundamentals/Convert_Template_BDE_to_ADO

Happy New Year and best wishes for great 2011!

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Nard Moseley (Digital Metaphors) wrote:

http://www.digital-metaphors.com/rbWiki/DADE/Fundamentals/Convert_Template_BDE_to_ADO

Thanks Nard,

Ah Ha! Done & Dusted. Thank you.

Followup question - In the Query Designer Fields view I have added a
field I don't need.

Danged if I can figure out how to remove it from the Selected Fields.

Regards & TIA,

Ian

nardmoseley

From the Query Designer Fields page you can double-click Selected fields
items to remove them.

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Nard Moseley (Digital Metaphors) wrote:


Now. I could have sworn I tried that.

Thak you. All fine now.

Ian