Solved

DBcolumn formula.

Posted on 2006-06-15
4
429 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Lotus notes email code 13 90
Username format for Domino LDAP 3 77
how to install domino server on suse linux 18 78
LotusScript: Merge Data to Word File 22 81
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 article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now