Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Display multiple fields in a combo box
Message
De
19/02/2002 02:35:38
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00621744
Message ID:
00621767
Vues:
8
>I have a combobox set up for rowsourcetype = fields and rowsource=tablename.field1,field2
>
>When the user selects something from the text box, both fields show up great. When the text box closes, only field1 continues to show.
>
>Is there a way to get both fields to continue to show in the displayvalue.
>(I can add the two fields together to accomplish this - but that makes the valids nasty and with proprortional fonts they don't line up well!)
>
>first element is 1 and column count is 2
>
>Thanks
>Donna

No, only first column goes to displayvalue. You could use SQL rowsource to add the displayvalue combination you want. With a SQL rowsource you would have the all columns reachable. ie:
with this
 .RowSourceType=3
 .Rowsource = 'select First_Name-(" "+Last_Name) as pname, '+;
              ' First_Name as fname, last_name as Lname, *'+;
              ' from employee into cursor crsEmployee'
 .Columncount = 3
 .Columnwidths = '0,100,100'
endwith
In valid check myCursor.Fieldname not value (though you might).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform