64 KB limitation question

HCL Domino Domino Forum
1

Greetings,

Although I’ve gotten no matches with searches on this subject in the R8 forum, can anyone advise if the 64 KB limitation on @dbLookup has been removed in the R8 release for server and Notes client?

I have a DialogBox with a lookup formula in an R5 application that has just reached this limit.

Thanks in advance for your advice.

Lee

2

Subject: There is no 64KB limitation on @DbLookup in Notes 6

The limitation is on the amount of data returned by a formula. I haven’t heard that this limit has been increased. You may want to consider breaking the field into two or more fields so that the user will not have to deal with such a long list.

3

Subject: Whoops, my error

Andre–Thank you for your response. I was in error. The field in question is defined as an editable dialog list, using the following formula for its choices:

REM {This is the standard setup for using lookup views to aid user selection.} ;

Class := “Notes” ;

Cache := “NoCache” ;

Server := “” ;

File := “” ;

View := “(CompanyLU)”;

Column := 1 ;

@DbColumn(Class:Cache;Server:File;View;Column)

The entries in the column referenced are sorted in ascending order, standard type (un-categorized.) The column value is computed by formula:

@Unique(CompanyName)

The view returns 2,825 documents. Recently the 64KB limit error appeared, probably as a result of adding some docs to the db.

So, is there a 64 kb limit on @dbColumn?

Thanks again,

Lee

4

Subject: You are asking the questions I already answered. Here are the answers again.

There is no 64KB limit on the return value of @DbLookup and @DbColumn.There is a 64KB limit on the amount of data returned by a formula. This is the limit you’re running into.

When you get an error message, please report the exact text of the error, not, e.g. “the 64KB limit error”. It’s not an issue here because your problem is obvious, but in general, this will help people figure out what your trouble is.

There is nothing you can do to make this work, the way you have it configured at present. You must either break this into multiple fields, so that the users select a value from one shorter list that limits the selections in the other field, or change your UI so that you’re no longer using a keyword formula, e.g. by selecting “Use view dialog for choices.”

There is no magic formula that will let you use more than 64K of keyword information in a single field. Sorry.

5

Subject: Ahhh.

Dear Andre,

Thanks for your response.

My lack of precision is probably attributed to working with Notes since release 3. :sunglasses:

I’ll aim higher, I promise.

Regards,

Lee