initial value ?

[Former Member]

hello friends..

in se11, while creating a table,in particularly while creating the fields..

there are 2 check buttons

1. key --this is to specify the primary key fields

2. initial value -- whats it purpose ?

[Former Member]

HI Selva,

Press F1 on that field. It is nicely explained.

Regards,

Ravi

[Former Member]

Hi, Go through this Doc:

Select this flag if a field to be inserted in the database is to be filled with initial values. The initial value used depends on the data type of the field.

Please note that fields in the database for which the this flag is not set can also be filled with initial values.

When you create a table, all fields of the table can be defined as NOT NULL and filled with an initial value. The same applies when converting the table. Only when new fields are added or inserted, are these filled with initial values. An exception is key fields. These are always filled automatically with initial values.

Restrictions and notes:

The initial value cannot be set for fields of data types LCHR, LRAW, and RAW. If the field length is greater than 32, the initial flag cannot be set for fields of data type NUMC.

If a new field is inserted in the table and the initial flag is set, the complete table is scanned on activation and an UPDATE is made to the new field. This can be very time-consuming.

If the initial flag is set for an included structure, this means that the attributes from the structure are transferred. That is, exactly those fields which are marked as initial in the definition have this attribute in the table as well.

Regards,

Anji

[Former Member]

> 2. initial value -- whats it purpose ?

It's use to have a value in the table when you create new entries.

Greetings,

Blag.

[Former Member]

Hi,

Initial value means, lets say you have 3 Primary keys and you selected this check box(Initial value) for those 3 values, if enter only 2 Primary key values and save the row, then the third onw will be filled with Default value (If it is a Charecter then it will be filled by Zero's, if it Numc then Zero's if it is date then it will be filled by 00000000)

Regards

Sudheer

[Former Member]

Hi,

The initial value check box is an Indicator to ensure that NOT NULL is forced for this field .

Select this flag if a field to be inserted in the database is to be filled with initial values. The initial value used depends on the data type of the field.

Regards,

Sowmya.

[Former Member]

thanx sowmya mam

[Former Member]

hi

good

key-If you select this indicator the field is flagged as a key field.

The key fields of a table must be located together at the beginning of the table, that is, no non-key fields are allowed between two key fields.

Initial Value->

Use

Select this flag if a field to be inserted in the database is to be filled with initial values. The initial value used depends on the data type of the field.

Please note that fields in the database for which the this flag is not set can also be filled with initial values.

When you create a table, all fields of the table can be defined as NOT NULL and filled with an initial value. The same applies when converting the table. Only when new fields are added or inserted, are these filled with initial values. An exception is key fields. These are always filled automatically with initial values.

Restrictions and notes:

The initial value cannot be set for fields of data types LCHR, LRAW, and RAW. If the field length is greater than 32, the initial flag cannot be set for fields of data type NUMC.

If a new field is inserted in the table and the initial flag is set, the complete table is scanned on activation and an UPDATE is made to the new field. This can be very time-consuming.

If the initial flag is set for an included structure, this means that the attributes from the structure are transferred. That is, exactly those fields which are marked as initial in the definition have this attribute in the table as well.

thanks

mrutyun^