Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


DBLookUp problem

Posted on 2003-10-23
Medium Priority
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 672 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 664 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.

Independent Software Vendors: 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

qwalette...im now reminding u :D


LVL 31

Assisted Solution

qwaletee earned 664 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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

610 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