?
Solved

Wrong type of data for listbox

Posted on 2003-11-13
3
Medium Priority
?
196 Views
Last Modified: 2013-12-18
I've got a form with a listbox in it. It looks up data from a view using the formulae
DbColumn("" : "NoCache"; ""; "2a. Fluids in use"; 2)
Unfortunately the data in column 2 are numbers, and so the listbox returns an error. How can I convert the values it sees into text? I'd prefer not to have to define the field displayed in column 2 as text as I want to work on the numbers elsewhere. I could create a hidden column with some code in it to convert the numbers to text and then look that one up I guess, but can't find a suitable command (only for text to number)
Thanks,
Stuart
0
Comment
Question by:StuartOrd
  • 2
3 Comments
 
LVL 31

Expert Comment

by:qwaletee
ID: 9743278
@Text(DbColumn("" : "NoCache"; ""; "2a. Fluids in use"; 2))
0
 
LVL 31

Accepted Solution

by:
qwaletee earned 500 total points
ID: 9743280
Well, fixing your typo...
@Text(@DbColumn("" : "NoCache"; ""; "2a. Fluids in use"; 2))
0
 

Author Comment

by:StuartOrd
ID: 9743420
Thanks, qwaletee
I'm still working on the others ones, you'll gather....
Stuart
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses

750 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