Q
Problem solve Get help with specific problems with your technologies, process and projects.

64 KB limit of dialog list

Can you please advise me on the 64 KB limit problem on the @DBLookup?

I have a Dialog list field which brings a list of documents from a view. Since the data has reached its limit, it gives the error message that "The specified database lookup generated more than 65,000 bytes of results, which is too large for Notes to handle in this context."

I have tried to create an array and assign all the values to it and then assign the array to that dialog list field, but it returns blank after it crosses the limit. I cannot use Picklist due to user limitations, otherwise, that would be a good solution.

Can you please suggest an alternative way to handle this 64 KB limit issue for @DBlookup?

What you are describing here is not actually a look-up issue, but the amount of data that is being returned to the field you are presenting as a dialog list, results in an array (list, whatever) that is greater than 64K in length.

That is, you now have a field which contains more than 64K AFTER the lookup has been performed.

I would thoroughly recommend looking at a great tip from Ben Langhinrichs, which discusses this issue and how to work around it.

Dig Deeper on Lotus Notes Domino Administration Tools

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchDataCenter

SearchContentManagement

Close