Mapping field name

[jvitantonio]

Hi,

I created an application with standard DB field names. Then I change them using the mapping fuctions but I noticed that formulas and stuff don't get updated.

Is there any way to map the field names and not change all the filds in the application manually? For requirement reasons, one fild today can be called in a one and tomorrow in a different way and I cannot be change the formulas every time I change a field name.

Any thoughts?

[#2]

hi

you can manage in an excel file (for example) the technical name and friendly name .

then in you application use this kind of code at the end of the load script :

Mapping_xls :

Mapping LOAD TECH_NAME, DISP_NAME FROM [..\Sources\mapping field.xls] (biff, embedded labels, table is Sheet1$);

Rename fields using Mapping_xls;

when a field name changes, you will have to update your excel file and simply reload your application.

hope this helps

Gilles

[jvitantonio]

Gilles, this does not answer my question. This is not what Im asking. I've already changed the names but what I need is a way NOT TO change ALL  the formulas in my application and put the new field name instead of the old one.

[#4]

Sorry for confusion. Anyway my suggested solution can help for future changes if you decide to use the friendly name in your formulas.

Another way you can investigate (i have not checked myself) :

Open Settings menu, then Expression overview. there is a find/replace button.

May it help ?

Regards

Gilles

[jvitantonio]

Gilles, Thanks again. Now this have more sense. I've tried this and it worked although it's not 100% convinient! Thanks for your time!