topic Re: Renaming a field in a table without reloading the table in App Development

Renaming a field in a table without reloading the table

Anonymous — Thu, 20 Apr 2017 14:45:45 GMT

Is it possible to do this?

It would make sense to say:

Rename field

from

Unfortunately this from syntax does not seem to exist in this context.

Instead all fields are renamed, which causes problems if you want to rename only the field of one table.

I work with noconcatenated tables, so I work with independand data.

Re: Renaming a field in a table without reloading the table

klausskalts — Thu, 20 Apr 2017 14:48:00 GMT

Rename field X to Y;

Should Work ....

Re: Renaming a field in a table without reloading the table

Anonymous — Thu, 20 Apr 2017 14:49:07 GMT

It does not work, if a different table already has a field Y.

The fieldname was Z btw.

Furthermore it renames fields in other tables that are also called X to Z.

Re: Renaming a field in a table without reloading the table

klausskalts — Fri, 21 Apr 2017 10:20:49 GMT

That's correct,

1) you cannot rename a field to a field name which already exists.

2) renaming a field will rename the field globally

But what is it you try to achieve?

One thing you might do is to utilize the ALIAS function. If you load all your Alias' in the beginning of the script then it should rename the fields as you go along.

Re: Renaming a field in a table without reloading the table

Anonymous — Fri, 28 Apr 2017 11:18:48 GMT

I solve this problem now by:

NOCONCATENATE LOAD

X AS 'Z'

FROM

[STH];

DROP FIELD

FROM