Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 496
  • Last Modified:

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

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
navgup
Asked:
navgup
  • 5
  • 2
1 Solution
 
AndrewJayPollackCommented:
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
 
AndrewJayPollackCommented:
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
 
AndrewJayPollackCommented:
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
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!

 
navgupAuthor Commented:
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
 
AndrewJayPollackCommented:
sample is right there.  if you send me the db, I'll try to look at your specific one tonight.
0
 
navgupAuthor Commented:
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
 
AndrewJayPollackCommented:
Thanks, Navgup -- I'm sorry it didn't work out.  I wish I understood the problem better.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now