Data types

[Former Member]

Hi experts,

I created table and I need to store some comment in the table. What is the most adequate type to store the comments. The length of the comment could be from few words to few sentences. I tried to create the type with string type but it is not allowed to create with that type.

[Former Member]

datatype ---x255.

[Former Member]

Hi,

You could use a variable length field like LCHR, this requires a INT2 field before it to declare the length and it must be the last field in the table. Have a look at the last two field in EDIDD.

Darren

[Former Member]

Hello,

Better add a field in the table with datatype TDOBNAME.

Create a standard text with the comment u want to show for the entry.

Hope this will helps you.

Cheers.

Vasanth

[Former Member]

U can use the data element CHAR255. There are many other data elements that you can use just write CHAR* and press F4. You will get list of character data elemnts.

[Former Member]

Hii,

give datatype as CHAR outputlength as 4000.

Neeraj

[Former Member]

TYPE XSTRING.

Amresh.

[former_member404244]

hi,

i guess u can give upto 255 characters .... for one field , if u want to store more than create other fields with same length and try to store the data...

while retriving take the fields which u added and concatenate them and then put it into one variable and then u can show...

Regards,

Nagaraj

[Former Member]

Thanks

[Former Member]

Hi ,

STRING is he type you have to use while defining dont specify the length it is variable length.

It is working.

Regards.