Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
.NULL. in combo's rowsource possible?
Message
De
30/04/2007 15:22:08
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
MS SQL Server
Divers
Thread ID:
01221232
Message ID:
01221241
Vues:
11
>Hello,
>
>I have a combo setup like the following (column2 descriptions removed for clarity):
>this.RowSourceType = 1
>this.ColumnCount = 2
>this.BoundColumn = 1
>this.ColumnLines = .F.
>this.RowSource = "0,,1,,2,,3,,4,,5,"
>this.BoundTo = .T.
>
>What I need is to have .NULL. as an item in the rowsource, so that when that item is selected, the null value gets put back into the controlsource.
>E.g. this.RowSource = ".NULL.,,0,,1,,2,,3,,4,,5,"
>
>Can this be done?

You can use Rowsourcetype=0, add all options to combo (using Additem), leave Controlsource empty and fill combo.value/save to table by using your own code, e.g.
If Combo.Value=='NULL'
  Replace yourfield With .NULL. in yourtable
endif
Edward Pikman
Independent Consultant
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform