Solved

DBcolumn formula.

Posted on 2006-06-15
4
437 Views
Last Modified: 2013-12-18
How can I use this to get a column value based on a specific fieldvalue instead of just putting in the column number?

F1 = PCB  ---- @DbColumn( "":"NOCache"; @DbName; "viewlookup"; instead of a number --2)
                                                                                                    I'd like to based it upon PCB and result will be
                                                                                                    values that is under PCB.
Hope I make sense. Thanks.
0
Comment
Question by:cyle
4 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16912439
Well, that's not a @DbColumn, that's @DbLookup:

    @DbLookup( class : cache ; server : database ; view ; key ; fieldName ; keywords )

Instead of the key, use PCB
0
 
LVL 63

Accepted Solution

by:
Zvonko earned 500 total points
ID: 16918108
If F1 is a DialogList then I would suggest to make the values behind the list text be the column numbers for the DbColumn lookup.
If F1 is not a DialogList then you need a heling variable to calculate the column number for the DbColumn parameter. For that column number calculation you could use someting like this:

@DbColumn( "":"NOCache"; @DbName; "viewlookup"; @Member(F1,"ACB":"PCB":"XCB"));



0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question