I have a view called “Sort Bin” How can it be that a dblookup(looking at “Sort Bin”) and the embedded view (“Sort Bin”)in the same form have different values? If I update a doc in the view for about ten minutes the dblookup still shows the old value but the view actually shows the new value I have tried LS notesview.refresh doesn’t work, I have updated FT index, run updall, F9 or Ctrl Shift F9, nothing works. Please help The only thing I can think is that NoCache & ReCache doesn’t work.
Mark Shepherd
Mark@vertigogroup.co.uk
Subject: A bug in the Client?
Are you sure that there are not two views with te same name in your db?Or maybe your embedded view is retreived form the server, and your @dblookup looks in the local replica?
Just guessing …
Subject: RE: A bug in the Client?
Or it might be something to do with the view’s refresh settings (automatic after first use, automatic etc…)
Or it might be that the user needs ‘create public views’ ticked in the ACL?
Just a few maybes…
Luke
Subject: RE: A bug in the Client?
Thanks for your suggestions however, the formula on the lookups is:@DbLookup(“”:NoCache;@Name([CN]; @Subset(@DbName; 1)):@Subset(@Text(@DbName);-1);“Sort Bin”;@Text(sort);3;[FailSilent])
even if I just use the replica ID the result is the same,
I have Manager access in the ACL with everything ticked.
My own feeling is that the on the client side the NoCache option is not working. The database only started doing this after the update to V6. A copy does the same thing. I used LS to update the backend view in the query save and you can see the embedded view updating.
Any more help would be gratefully received.
Mark
Subject: Theres your problem, no ""s try…
@DbLookup(“”:“NoCache”; “” : “”;“Sort Bin”;@Text(sort);3;[FailSilent])
Subject: RE: Theres your problem, no ""s try…
yhankyou very very much, I was tearing my hair out.Mark