At 05:11 PM 3/6/2012, Bill Niehaus wrote:
Mike,
I haven't used the ListBox or ListView before. They look like they could be
useful alternatives.
Bill,
Yes, you will definitely like the look and feel of Variable Lookup ListView
control in form designer, not to mention the Custom Column Headings, ability
to sort by simply clicking on the column header, Multi-Select, Zebra Stripe,
On Enter EEP, On Exit EEP, On Click EEP, On Double-Click EEP, On Right-Click
EEP, and much more ...
Based upon your table structure (provided in original post), I have prepared
a simple but cool Variable Form which you can use, and be able to take full
advantage of Variable Lookup ListView control in R:BASE eXtreme 9.1 and 9.5
for Windows. Of course, I had fun putting together this sample app for you!
-- Your CHOOSE Command:
CHOOSE vTrialTxt FROM #VALUES +
FOR ((LJS(Trial,7))&(LJS(TrialLocation,15))&(LJS(TrialTitle,30))),Trial +
FROM TrialNo ORDER BY Trial DESC ...
-- Same data using the Variable Lookup ListView
http://www.razzak.com/sampleapplications/VariableLookupListView.jpg
Database: ClinicalTrials
Form: ClinicalTrials
Command File: ClinicalTrials.DAT
Double-Clicking on the selected item will return the required vTrial
variable as INTEGER. There is no need to retrieve the value as TEXT,
and then convert to INTEGER when using the Variable Lookup ListView.
Check your e-mail for complete details and a link to download the sample
application.
Enjoy!
Very Best R:egards,
Razzak.
