topic Select-Option and Dump in Application Development and Automation Discussions

Select-Option and Dump

Former Member — Wed, 14 Sep 2011 07:32:59 GMT

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

Re: Select-Option and Dump

former_member209703 — Wed, 14 Sep 2011 08:26:26 GMT

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

Re: Select-Option and Dump

Former Member — Wed, 14 Sep 2011 09:59:58 GMT

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