Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete records and requery
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Conférences & événements
Divers
Thread ID:
00012109
Message ID:
00012557
Vues:
51
>>>I have a list box based on a table. The user can choose to delete a record from the list box. After I used a SQL statment to delete the record, it still appears in the list box even though I REQUERY the form. I tried the PACK command, but it will close all my table and the entire list box becomes blank.
>>>
>>>How do I REQUERY the table from a list box after I deleted a record?
>>
>> did you try to .REFRESH() the list box
>>
>>Arnon
>Also try setting DELETED ON, a requery will still pull in deleted records.
>
>HTH,
>Greg

Not sure about this in VFP but you are probibly still sittin on the deleted record. Try going to a new record with skip or something .
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform