Syntax error / Database table problem concerning large data types

[Former Member]

Hello Dev Experts,

I'm currently working on a table control that will be one field that will need to save around 200-300 lines of text. (The purpose of this is to save a certification document in an editable and clean format that can have any amount of variations/macros put in).

In making the database table, instead of saving every line in the table control as its own record (trying to avoid a billion records here) I would like to have one very large field/data-type capable of saving the entire contents of the table control.

I see there are data types capable of 32000 characters which might work for my purposes. However, seemingly you can only have a string be that big in a table (When I add CHAR, I says it has to be smaller than 4030 characters)? Also, with a string the table is no longer a flat structure so I cannot declare it in a program without getting a syntax error: ""ZLAB_CERTS_TEXT" must be a flat structure. You cannot use internal tables, strings, references, or structures as components ."

Please help me!

<< Moderator message - Everyone's problem is important. Please do not ask for help quickly. >>

Thanks!

Brian Waugh

ABAP Developer

Latrobe Specialty Steel Co.

Edited by: bwaugh06 on Dec 14, 2010 8:16 PM

Edited by: Rob Burbank on Dec 14, 2010 2:21 PM

[Former Member]

hello,

May be you can use standard text for your requirement

also please see EDIT_TEXT and SAVE_TEXT function module

Thanks

[Former Member]

Thank you, that is helpful. I will begin looking into that.

[Clemenss]

Hi bwaugh06

You may use a text edit control instead od table control and store the content in a field of type STRING: No space wasted if no data is there but you have unlimited length.

Regards,

Clemens