I want to display only the first 3 documents from a view onto a ‘computed text’ on a form. I am using the @subset(@dbcolumn(…);3) command for the same. The problem is, the @dbcolumn which initially fetches all the documents from the view does not return anything to the outer @subset because the data fetched by the @dbcolumn is exceeding 65,000 bytes and thus the @subset is returning null.
Is there any other way, in such situation(dbcolumn returns data excedding 65,000 bytes size), that I can get the first 3 documents from the view?
I would appreciate any help regarding this…
Subject: RE: How to get documents from view if the size exceed 65,000 bytes?
I think you’re mistaking the cause of the problem. @Subset works just fine with @DbColumn return values exceeding 64K. You’re probably reading the data from the wrong column or something.
However, even if you can get this formula working, I think it’s not a good idea. Reading that much data every time you open a document is a real performance killer, especially for any users that might happen to have a slower connection to your server. You might consider using an embedded view instead, or else retrieve the information with LotusScript (perhaps in the Queryopen event) so that you don’t have to scan through an entire view just to get the first three rows.
Subject: RE: How to get documents from view if the size exceed 65,000 bytes?
Thank you very much Andre.Well, just to give you an idea, the code that I have written works just fine when the number of documents in the view is less. The problem occurs when the data is too large.
But thanks for the suggestion of retrieving the information with LotusScript. Will give it a try 
Thank you once again.