Home > Ask the Domino Experts > Domino Development Questions & Answers > Use scheduled agent to refresh all @DBLookup/computed values
Ask The Domino Expert: Questions & Answers
EMAIL THIS

Use scheduled agent to refresh all @DBLookup/computed values

Andre Guirard EXPERT RESPONSE FROM: Andre Guirard

Pose a Question
Other Domino Categories
Meet all Domino Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 15 October 2004
I am trying to refresh all @DBLookup/computed values within a document using a scheduled agent.

Manually, this does the job: @Command([ToolsRefreshAllDocs])

I have tried using the LotusScript below, too, but this doesn't seem to work either: 

If doc.computewithform
(True, False) Then 
Call doc.save(True, False)

Do you have any suggestions?


>
ComputeWithForm does work with @DBLookup as well as other computed fields, but you have to consider the different context of code running on your workstation versus on the server. The current username is the server name rather than yours, and if you want to refer to a database on the current server, you should use "" in your formula rather than a hard-coded server name. To write a formula that will work both on the server and on a workstation, use "" to refer to the current database, or if to another database on the same server, use @Subset(@DbName; 1) : "filepath", or use the replica ID of the second database.

If the database is on another server, you may need to make sure there's a "trust" relationship between the servers. The Server configuration document of the second server in the server address book contains a field on the Security tab labeled "Trusted servers." It should list the server running the agent.

Do you have comments on this Ask the Expert Q&A? Let us know.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Domino Development
Can I create and copy Microsoft Excel spreadsheets with LotusScript?
'Illegal circular use: Audit Trail' error when opening Lotus Notes docs
How to make computed fields recalculate
Sending and logging faxes from Lotus Notes and Domino
Accessing documents in a Lotus Notes database
Adding an action to the Lotus Notes right-click menu
Writing temporary text files that email as attachments
Trapping the on-click event of a radio button
Copying a form object using LotusScript
Connecting to a remote DB2 server with LEI

Lotus Notes Domino Agents
How the Agent Profiler tool improves Notes/Domino performance
Run or restart Notes/Domino agents via text messages
Calculating results for a column in a Lotus Notes view
Approve Lotus Notes documents using a BlackBerry mobile device
LotusScript agent indexes Lotus Notes/Domino databases
Top 10 Lotus Notes/Domino coding and development tips of 2008
Open documents in Lotus Notes from the Web without a UNID
Fix and update Lotus Notes documents with limited access
Verify scheduled agent status with Domino Extensible Language (DXL)
Top 10 Lotus Notes Domino programming and development tips of 2007

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Lotus Notes Domino on Blackberry and mobile devices
HomeTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersDomino IT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy 		  TechTarget - The IT Media ROI Experts