Working with large body fieldds

Hello all !

I am working on application that will allow our users to send an email to a custom Notes database. Users of the custom DB can then view documents mailed in and assign them to others to work on.

This means that the form used to create the initial document is changed from ‘memo’ to ‘formxyz’ so that the mailed in doc can appear in the right places of the app. This is all working fine.

What is not working is for documents that are mailed in that have large/multiple body fields. For example a mail which is sent in with a screenshot and two attachments. The attachments show correctly but the body field (copied from the memo form of a mail db) shows the error -

ERROR: Field is too large (32K) or View's column & selection formulas are too large     

My question is how can I get around this ? I’d really like the screensnap to be visible in my app. Perhaps it could be converted to a file by the database ?

Any help would be really appreciated !

Thanks

Matthew

Subject: Working with large body fieldds.

Have you checked the Body fields type really is Rich text ? Only text fields have this limitation of 32K

Subject: Working with large body fields.

Dear David,

Thanks for your reply. I have checked and the field is definitely a rich text field. One thing though - when I change the form name of the document I copy the body field to a field called CallFullDescription by using the command :

Field CallFullDescription := Body

Maybe this is what is screwing me over - do I need to copy the field using another method ?

Many thanks for your help,

Matthew

Subject: RE: Working with large body fields.

David,

I can confim my theory now. If I unhide the original body field on the document it shows the contents correctly. It’s defintely the way that I copy the field body to the field CallFullDescription.

If you have any quick ideas that would be great - but I have a lead now !

Thanks

Matthew