DBLookUp problem

Posted on 2003-10-23
Last Modified: 2013-12-18
IM using @DBLookup to populate a field in my report form. The code works ok for small data, but when im generating the report for 1065 records (each field, in effect will hold 1065 records as well) this error message appeard "Paragraph or field cannot be larger than 64kbytes). How can I generate my report?

Hoping for a prompt reply. Thanks in advance.
Question by:macjacinto
LVL 15

Accepted Solution

Bozzie4 earned 168 total points
ID: 9605929
Well, you can't have more than 64K in a field.  Not in a normail textfield, anyway.

You could generate your report in a RichText field, because that can hold more data.
And please post your code, it's very difficult to grasp what you are trying to do.



Expert Comment

ID: 9606513
Oh Boy....
LVL 14

Assisted Solution

p_partha earned 166 total points
ID: 9606668
From the help:
@DbLookup can return no more than 64KB of data. Use the following equations to determine how much of your data can be returned with @DbLookup.
For lookups that return text:
2 + (2 * number of entries returned) + total text size of all entries
Each text string is limited to 511 bytes; if only one text string is returned, it is limited to 64KB.
For lookups that return numbers or dates:
(10 * number of entries returned) + 6

There are workarounds for it, If you tell us whether it is in web or notesclient, accordingly we can tell.

LVL 31

Expert Comment

ID: 9611003
You may want to try LotusScript to work around issues with DbLookup limits.  Field limits are a different problem.  You may need to break the data out into multiple felds, or you may have to do a dair bit of processing to get chunks of it intoo a rich text field AS SEPARATE PARAGRAPHS.
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline


Author Comment

ID: 9612079
here's the code i used in the field

@DbLookup("": "NoCache" ; "": ""; view ; @Trim(tcovereddate) ; 2 )

each record of is 10 characters long

ill be using it for notes client


Author Comment

ID: 9612095
I would deeply appreciate the lotuscript code work around for this.

Thanks in advance!
LVL 31

Expert Comment

ID: 9617673
Remind me next week.

Author Comment

ID: 9669183
i already tried making the field a rich text field, the form appears but no value was shown now reminding u :D


LVL 31

Assisted Solution

qwaletee earned 166 total points
ID: 9684727
OK, the first thing is to understand how to use LotusScript to retrieve the same data as your DbLookup.

Dim tcovereddate as string
tcoveredDate = "....................... you need to assign this ......................."

Dim s as new notesSession
Dim db as notesDatabase
Dim view as notesView
Dim entries as notesViewNavigator
Dim entry as notesViewEntry
Dim onealue as string

Set db = s.currentDatabase
Set view = db.getView("ate")
set entries = view.createViewNavFromCategory(trim(tcovereddate))
Set entry = etries.getFirst
Do Until entry is Nothing
   oneValue = entry.columnValues(2)
   '    ************ do something with the value! ************
   Set entry = entries.getNext(entry)

Now, what to do with:
   '    ************ do something with the value! ************
...?  We'll get there in a minute.

So, we have to place the data in <64k chunks into Rich Text.  S, where we have:
   '    ************ do something with the value! ************
... we should append the value to an "allValues string" variables, and when it gets close to 64k, dump it into its own rich text field.

How to do that? Create a little form with a PLAIN TEXT field to hold the accumulated "allValues"  Then use notesDocument.renderToRchTextItem to stuff this chunk into a central field on a different document.

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now