topic Re: Syntax error / Database table problem concerning large data types in Application Development and Automation Discussions

Syntax error / Database table problem concerning large data types

Former Member — Tue, 14 Dec 2010 19:16:10 GMT

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

Re: Syntax error / Database table problem concerning large data types

Former Member — Tue, 14 Dec 2010 20:05:41 GMT

hello,

May be you can use standard text for your requirement

also please see EDIT_TEXT and SAVE_TEXT function module

Thanks

Re: Syntax error / Database table problem concerning large data types

Former Member — Tue, 14 Dec 2010 20:20:22 GMT

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

Re: Syntax error / Database table problem concerning large data types

Clemenss — Tue, 14 Dec 2010 21:18:13 GMT

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