DBLookUp problem

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.
macjacintoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bozzie4IT ArchitectCommented:
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.

cheers,

tom
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ArunkumarCommented:
Oh Boy....
0
p_parthaCommented:
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.

Partha
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

qwaleteeCommented:
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.
0
macjacintoAuthor Commented:
here's the code i used in the field

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

each record of is 10 characters long

ill be using it for notes client


0
macjacintoAuthor Commented:
I would deeply appreciate the lotuscript code work around for this.

Thanks in advance!
0
qwaleteeCommented:
Remind me next week.
0
macjacintoAuthor Commented:
i already tried making the field a rich text field, the form appears but no value was shown

qwalette...im now reminding u :D

help!!

0
qwaleteeCommented:
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)
Loop


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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.