Re: help forms 4.5 : Changing names of tables

From: <matti.siren_at_comptel.fi>
Date: 1996/02/15
Message-ID: <4fvi46$r02_at_pinta.kolumbus.fi>#1/1


In article <4ftikm$fjo_at_vivaldi.telepac.pt>,

   jagra_at_mail.telepac.pt (Jorge Agra) wrote:

>In a project I'm in there's a need to change the names of some
>tables and their fields, the problem here is that there are many
>forms that use those tables.
>
>Anyone knows of an easy way to automate the job of changing the
>forms to reflect the new names ?

How about creating public or private synonyms for the old names? The forms would reference the tables and fields by the old names that are translated to the new names via the synonyms. This way, you wouldn't have to modify your existing forms. Depending on how your forms access the database, you might also do the translation using views.

Regards,

Mr. Matti Siren
Comptel Received on Thu Feb 15 1996 - 00:00:00 CET

Original text of this message