Solved

DBcolumn formula.

Posted on 2006-06-15
4
445 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

738 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