Urgent : Field Size Limitation.

I have a Keyword field, with Formula having @DBCommand function which is displaying Description of Items from Backend as SQL Server.
Now as you are aware that Field size limit is 64KB in any case, as my results of Description is exceeding limit and not displaying some last records. As soon as data is incresing in backend records for display is decresing.
So any one of you can suggest any solution for this??? I have faced this kind of probleme for the first time.

I want answer as soon as possible at my e-mail

Who is Participating?
ghassan99Connect With a Mentor Commented:
There is no way around this problem, even in R5.  Since u r getting the results from the SQL server, I suggest the following: split the data in 2 fields according to some condition, this way u will have like 128k.  store the values in the first field then the rest in the other field.
Lata071698Author Commented:
Adjusted points to 400
I think splitting up the data into two or more fields or columns doesn't do the trick. As at the end the data as to be shown in one list you still will exceed the 64K limit.

Lata, could you tell as a little more about what are you trying to do in your application. Maybe there is a workaround by going for a different approach.
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I hate to disappoint u MW, but Lata accomplished his job using a variation of my suggestion.
I'm not disappointed at all, ghassan. Hope you get the points then :-)

Actually I try to keep myself out of questions where it comes to Notes limitations. Workarounds are usually hard find or not available at all (like the case of the validation of RTFs)
Nope, this question is bound for deletion:)

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.

All Courses

From novice to tech pro — start learning today.