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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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.

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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.

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Lotus Notes - Broken Links report 5 223
Lotus notes email code 2 131
Migration Lotus to Exchange 2016 4 221
Save conflict messages on existing documents 15 89
This is an old article, please see an updated version of this article, located here:
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

730 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