Notes Ninjas Notes Ninjas
Lotus Notes hints, tips, error messages
Tick Generate unique keys in index to create fast category lookup view

Hint Short Cut: Add this to your code & documentation to help you find this page.
http://www.notesninjas.com/#FastCategoryLookup or http://www.notesninjas.com/A555F9/nn.nsf/ByAlias/FastCategoryLookup


Sometimes you need to do a dbcolumn on  a view to pick up previously used category values. This little trick makes the view refresh much quicker and can avoid the 64 limit.





In the view properties go to the propeller hat tab and tick the ODBC area that says Generate unique keys in index.

 

Check out the view now. No @Unique needed and faster refresh.

 

 Jump to:     Notes Tips
    Lotus Notes Index 
  Register for Tips
Previous Lotus Notes Tip 
    Next Lotus Notes Tip
Your company logo here?
Adam Foster
Free Cash Making Web Site
Free Revenue Earning Blog Site
 Free Revenue Earning Newsletter Site   
Free Search Pages Free Web stats
Free Contact Us page
Cheap .com domain names
 Need a website or 
   Lotus Notes
  problem solved?
Adam Foster
Lotus Notes 5 All-in-one Certification Exam Guide by Libby Schwarz, Ben Malekzadeh
Sort out your CLP with this book.
See at: Amazon.co.uk | Amazon.com |