topic Re: Data types in Application Development and Automation Discussions

Data types

Former Member — Tue, 04 Nov 2008 09:05:25 GMT

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.

Re: Data types

Former Member — Tue, 04 Nov 2008 09:07:33 GMT

datatype ---x255.

Re: Data types

Former Member — Tue, 04 Nov 2008 09:08:57 GMT

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

Re: Data types

Former Member — Tue, 04 Nov 2008 09:09:17 GMT

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

Re: Data types

Former Member — Tue, 04 Nov 2008 09:09:20 GMT

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.

Re: Data types

Former Member — Tue, 04 Nov 2008 09:09:26 GMT

Hii,

give datatype as CHAR outputlength as 4000.

Neeraj

Re: Data types

Former Member — Tue, 04 Nov 2008 09:11:32 GMT

TYPE XSTRING.

Amresh.

Re: Data types

former_member404244 — Tue, 04 Nov 2008 09:11:34 GMT

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

Re: Data types

Former Member — Tue, 04 Nov 2008 09:13:13 GMT

Thanks

Re: Data types

Former Member — Tue, 04 Nov 2008 09:15:12 GMT

Hi ,

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

It is working.

Regards.