Select-Option and Dump

[Former Member]

Hi All,

I have select-option on selection screen.

Entered 7000 values to select-option.

When executed it dumps, but small input values report is executed.

Is their any limitation for input values in select-option.

Moderator message: FAQ, please search for previous discussions of this topic.

Edited by: Thomas Zloch on Sep 14, 2011 3:02 PM

[former_member209703]

Hi

As far as i know the limitation comes from the maximum size of a query in the underlying DB System. When using Select-Options in a Select statement, those options are internally converted into a valid SQL statement, so if the number of options exceeds a specific limit the SQL statement becomes too big for the DB System to handle it, so the system dumps.

Regards

[Former Member]

Hi,

problem is not with select option, it can contain milions of entries.

You are propably using select option in where condition of your select statement. You should keep limit about 1000-2000 entries, it depends on db system and memory.

Regards

Matus