topic Re: table in Application Development and Automation Discussions

table

Former Member — Wed, 04 Jul 2007 06:40:26 GMT

Hi all,

I have created a Z table which has a field MAIL1. i changed it's type from CHAR to STRING.But when i activate the program - it says the Z table should be a flat structure :; you cannot use internal table, strings, references.......................wat could be wrong? kindly reply

thanks .

Re: table

amit_khare — Wed, 04 Jul 2007 06:42:45 GMT

You cannot have type STRING in Tables/Structures.

Instead use a CHAR type as per requirement.

like CHAR255.

Regards,

Amit

reward all helpful replies.

Re: table

Former Member — Wed, 04 Jul 2007 06:42:59 GMT

hi,

chk if u have used it elsewhere in some program. If so comment it and activate again.

regards,

raksha

Re: table

Former Member — Wed, 04 Jul 2007 06:44:09 GMT

Hi Kavita ,

You cannot use string as a feild in a table , what i would suggest is you use the data type CHAR255.

Regards

Arun

Re: table

Former Member — Wed, 04 Jul 2007 06:45:17 GMT

HI Kavitha,

Delete the Field and create a new one.

Data type : String Length : 256.

It will work.

Thanks.

Re: table

Former Member — Wed, 04 Jul 2007 06:51:13 GMT

<b>After changing the datatype of the field,

GOTO UTILITIES->DATABASE UTILITY->ACTIVATE AND ADJUST DATABASE.

Regards,

Pavan P.</b>

Re: table

Former Member — Wed, 04 Jul 2007 06:51:23 GMT

U canot use the string type in Table instead use char type.

Thanks

Re: table

Former Member — Wed, 04 Jul 2007 06:57:13 GMT

hi kavitha,

when ever u have changed a database table then u sholud adjust it and activate it again as after completing all ur changes in SE11 -> UTILITIES -> DATABASE UTILITY -> CLICK ON ACTIVATE AND ADJUST DATABASE. then only all ur changes are reflected in database otherwise previous version of activated will take and displays same error again n again.

if helpful reward some points,

with regards,

Suresh.A

Re: table

Former Member — Wed, 04 Jul 2007 07:20:37 GMT

Hi kavitha

you cannot use string in tables so u better use char type as

CHAR255

if use reward points

Regards,

Azhar