Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do you write DbLookups so they work on a local database and on the server?

April 26, 2017database local server write

0

Posted

How do you write DbLookups so they work on a local database and on the server?

1 Answer

0

Posted

Use @Dbname to test for the location using these formulas:: DBName := @Text(@DbName); Server := @Subset(DBName; 1); Database := “KeywordLookup”; ClassCache := “Notes” : “NoCache”; View := “LookupKW”; Key := “Key Name”; @DbLookup(ClassCache; Server : Database; View; Key; “Ret_Value”) Now you can substitute the Server and Database variables everywhere in the Notes application. DbLookups or @Commands will automatically run local when the user is local and run on the server when the user is on the server.