?
Solved

64K bytes error with text field or rtf while opening / closing doc

Posted on 2003-02-22
7
Medium Priority
?
488 Views
Last Modified: 2013-12-18
In Notes 5.07 i am using a multivalue text field using check box(s) that has a long list of values to select from.
All the time before saving the document i get this error msg:
Paragraph or field cannot be larger than 64K bytes.

I very well know that i cannot store more than 15k in a text field and i tried IsSummary = False and everything i possibly can. I also tried to dump the selected value from the list into a rtf, that also did not worked.

Does anyone has any suggestion to get around this problem thru CAPI or some other ways?

I don;t want to split the fields. I have tried dumping the values into RTF. Tried IsSummary.

If someone can send me code that works i will give additional 200 points on it.

navgup@hotmail.com

0
Comment
Question by:navgup
[X]
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
  • 5
  • 2
7 Comments
 
LVL 5

Expert Comment

by:AndrewJayPollack
ID: 8001170
Navgup,  the 64k limit you are running into is usually associated with the transfer of data from a dbcolumn or lookup, but I suppose it could also be just data stored in the field value list.

The best way around it is to put the data to populate the keyword list in a view, and use a view lookup type dialog rather than a dialog list type dialog to get the results.

You put your lookup values in a view.  This ALSO gives you a better looking dialog box, and lets you categorize your values for much better user interface when picking values.

Let me know if you need more detail or example, but this should resolve the issue since you're displaying a view in that dialog box, so you're not transfer any data beyone what the user actually picks.
0
 
LVL 5

Accepted Solution

by:
AndrewJayPollack earned 400 total points
ID: 8001194
Navgup -- I have another alternative here.

Since you're not getting the error message earlier than save time, my guess it's on save with many selected items that you get this message.

I'll be your check box choices are long.

Instead of choices like this:

choose this really .....long sentence
choose this really .....long sentence
choose this really .....long sentence
choose this really .....long sentence
choose this really .....long sentence

try this:

choose this really .....long sentence | 1
choose this really .....long sentence | 2
choose this really .....long sentence | 3
choose this really .....long sentence | 4

what gets saved will be the number in a text string (e.g. "1" or "2" -- if multiples are picked it'll be a list "1":"2":"3")

Now, downside is you have to change code in the db to test for the number (remember, always as a string) instead of the string, but it will greatly reduce the size of what gets saved.
0
 
LVL 5

Expert Comment

by:AndrewJayPollack
ID: 8002793
Navgup - last thing -- you'll need to this in reverse when you want to display the result somewhere.  In other words, replace the number, with the stored text for display.  I know this can be a pain, but it CAN work.  

You could also put code in querysave() that writes the text value to a rich text field at save time based on the number values that end up in the field.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:navgup
ID: 8003734
Thanks for the response.
I m right now trying to code around the suggestion. Please send me an example or sample if you can.

Thank you,
navgup@hotmail.com
0
 
LVL 5

Expert Comment

by:AndrewJayPollack
ID: 8003890
sample is right there.  if you send me the db, I'll try to look at your specific one tonight.
0
 

Author Comment

by:navgup
ID: 8085683
It was a nice approach but that didnot helped much. But as a thank you I am offering what i promised. Thank again AndrewJayPollack !
0
 
LVL 5

Expert Comment

by:AndrewJayPollack
ID: 8085767
Thanks, Navgup -- I'm sorry it didn't work out.  I wish I understood the problem better.
0

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

IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

800 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