topic tables in Application Development and Automation Discussions

tables

Former Member — Wed, 27 Dec 2006 17:51:28 GMT

Hi all,

How to change the field size of a field if the table has a reference with the other table..

Re: tables

Former Member — Wed, 27 Dec 2006 17:55:39 GMT

Hi all,

How to change the type of the field if the table has a reference table

Re: tables

Former Member — Wed, 27 Dec 2006 17:55:49 GMT

U should delete the reference, change the data element for the field and insert the reference again.

Anyway if you change the size of the field, probably you'll have to use the database utility to adjust the database too.

Max

Re: tables

Former Member — Wed, 27 Dec 2006 17:58:05 GMT

What are database utilities

Re: tables

Former Member — Wed, 27 Dec 2006 18:03:31 GMT

It's the tool to adjust the database image of the table.

The SE11 corrects only the dictionary structure and then when it actives the table the system should be create the correct image of the table in the database, but this action sometimes fails when the format of an old field is changed, so It has to force this action by database utility:

From SE11:

Utilities->Database Utility

or trx SE14

Anyway after activing the table the system should advise you if you have or don't have to use the database utility.

Max