Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Editing a member in a COMBO BOX?
Message
De
12/11/1997 16:15:20
 
 
À
12/11/1997 16:05:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00059768
Message ID:
00059807
Vues:
39
>>>>>I would like to edit a member of a COMBO BOX and
>>>>>save the changes to my table. any ideas?
>>>>
>>>>Basically, you just edit appropriate field from rowsource (cursor).
>>>>Why not to make search in UT? You asked this question many times before.
>>>I am taking about making a change in the combox box value area and
>>>having that change saved to your table... here is the code I have
>>>in the VALID event.
>>>
>>>replace name with thisform.combo1.displayvalue
>>>thisform.combo1.requery()
>>>It is not working...
>>>The questions I have asked concerning the combo boxz were about adding.
>>
>>Well, it's something like this:
>>*** Combo.InteractiveChange event
>>if not empty(this.value)
>> this.tag=table1.name
>>endif
>>*** Combo.Lostfocus event
>>local cDisplayvalue
>>cDisplayvalue=this.displayvalue
>>if this.value<>cDisplayvalue
>> select table1
>> locate for name=this.tag
>> replace name with this.displayvalue
>> this.requery
>> this.value=cDisplayvalue
>>endif
>>this.tag=""
>>I hope, you use unbound combo.
>
>Well Ed - I have to say thank you again. This is what I have done:
>*** Combo.InteractiveChange event
> this.tag=mytable.name
> local cDisplayvalue
> cDisplayvalue=this.displayvalue
> if this.value<>cDisplayvalue
> select mytable
> locate for name=this.tag
> replace name with this.displayvalue
> this.requery
> endif
>This works great if you want to edit you combo box without buffering.
>thanks Ed - :))))))))

Using InteractiveChange only, you will trigger replacing extra times (when user in the middle of editing). It might be Ok for quick test, but in real situation with implemented RI, it could create tremendous overhead. I think Lostfocus is a little bit better, however I'm not sure that the idea to edit combo items on fly is robust at all.
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform