parameter selection list failure: too many records?

alessandro paganini

I'm setting up a selection list for a parameter, but it fails
[SELECT CardCode, CardName FROM OCRD ORDER BY CardName]

I think it's related to the number of retrieved records, cause limiting it to 100 works
[SELECT TOP 100 CardCode, CardName FROM OCRD ORDER BY CardName]

Is this a bug? Will it be addressed?
Or instaed there's a specification of max number of records allowable?
In such a case, how many?

thanks bye
Alessandro - Vesuvius Italia Spa

Philipp Knecht

Hi Alessandro

There is no built in limitation of rows.
The whole result gets filled into a B1 ComboBox which as it seems cannot handle that many records.

With new Version we have implemented also ChooseFromList which is much more performant and suitable for many records.

hth